ssis-2012 Questions
10
This question was asked here before but the solutions proposed don't seem to be working for me.
I'm trying to import a text file pipe delimited text qualifier ". The SSIS package is returning the ...
Fabio asked 4/6, 2017 at 23:18
7
Solved
I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component:
===================================
Method not found: 'Void Microsoft.Da...
Heterodyne asked 15/3, 2016 at 11:16
6
Solved
DECLARE @PATH NVARCHAR(1000) = N'\\MY-SERVER\C$\Folder\\'
DECLARE @TABLE NVARCHAR(50) = SUBSTRING(@FILENAME,0,CHARINDEX('.',@FILENAME))
DECLARE @SQL NVARCHAR(4000) =
N'IF OBJECT_ID(''dbo.' + @TAB...
Onondaga asked 30/11, 2017 at 16:50
6
I am getting these errors in flat file connection manager.
Error: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0...
Nineteen asked 5/9, 2014 at 12:54
2
Solved
I have created an SSIS Package and deployed it on Server.
While execution of Package i can see the report of Execution.
i want to know that in which table SSIS execution id's information is store...
Auberon asked 1/8, 2019 at 8:12
3
Solved
I am importing a data set from Oracle using SSIS. SSIS is gives me a warning:
Truncation may occur due to retrieving data from database column "Third Party" with a length of 28 to data flow col...
Fairhaired asked 3/4, 2019 at 17:33
4
Solved
I am working on building a new SSIS project from scratch. I want to work with couple of my teammates. I was hoping to get a suggestion on how we can have some have some source control, so that few ...
Jocund asked 11/5, 2016 at 19:17
3
Solved
This may sound like an easy question but the answers on the net all point to the basics of setting up an environment and referencing it in the project/package.
The scenario that I have encountered...
Rhyner asked 1/4, 2014 at 2:56
5
Solved
using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is set to CRLF, but when it processes the file, I have a text column that has an LF in it. This is c...
Gentilis asked 24/5, 2017 at 16:58
5
Solved
I can copy files between two servers say Server A and Server B manually and I have permissions to folders on either side.
I am using File System Task to Copy files.
When my Source and Destination...
Sueannsuede asked 9/6, 2017 at 11:37
6
Solved
I have an SSIS Package, which contains multiple flows.
Each flow is responsible for creating a "staging" table, which gets filled up after creation.
These tables are global temporary tables.
I ad...
Greaves asked 20/8, 2013 at 23:21
2
I am trying to execute the package and every time I see the following error. Especially when I execute the data flow task.
Error :
System.IO.IOException: The process cannot access the file
'C...
Infective asked 19/3, 2019 at 20:57
2
Solved
I'm trying to connect to a SFTP server via an SSIS package. The package executes WinSCP with the following connection string in a .txt file:
open sftp://username:fc$#[email protected]:22
H...
4
Solved
I am working on a project which was owned by a different person. He created a job to update bunch of fields in handful of tables in SQL server. That job was based on an SSIS package. Now I have the...
Antecedents asked 29/5, 2019 at 20:58
1
Solved
I Have to Upload Data in SQL Server from .dbf Files through SSIS.
My Output Column is fixed but the input column is not fixed because the files come from the client and the client may have updated ...
Mushy asked 20/2, 2019 at 7:33
5
Solved
I am getting the following error when I try and run my package. I am new to ssis. Any suggestions. Tahnks
===================================
Package Validation Error (Package Validation Error)
...
3
Solved
I've have SSIS Package that is exporting 2.5 GB OF DATA containing 10 million records into Sql Server Database which has 10 partitions including PRIMARY FILE GROUP.
Before Changing default Max In...
Preliminary asked 9/12, 2016 at 6:5
1
Solved
When I run the following package, it completes every task successfully until loading into the destination where 0 rows are written. I reduced the buffer size but still didn't work.
Any clue on how ...
Canteen asked 9/4, 2018 at 21:21
3
I am new to SSIS.
I created SSIS Package using Execute SQL Task. I called a Stored Procedure.
My stored procedure prints few messages like
'Insert Started'
'Update Started'
'Update Completed'
but...
2
Solved
We migrated packages from Visual Studio 2012 to 2017
There is no cdc source component in the ssis toolbox:
and the cdc source component looks like:
And cannot be opened as well.
If I create...
Counterblast asked 20/12, 2017 at 9:36
2
Solved
This is what I'm trying to do in a script task:
long lngMaxRowsToPull = Convert.ToInt64(Dts.Variables["Project::MaxRowsPerPull"].Value);
I get an error message that the variable does not exist.
...
1
Solved
I'm still fairly new to SSIS. I've figured out how to download packages from a server by connecting to Integration Services. How do I download packages from SSISDB? Background: We have a TON of pac...
Tergal asked 25/11, 2017 at 1:6
1
There were announcements back in 2011 about Microsoft SQL Server OLEDB access going retire, now I heard it has been deprecating starting SQL SERVER 2014? However it is not apparent from MSDN pages ...
Hanes asked 18/12, 2015 at 3:1
6
Solved
My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image)
I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get...
1
In SSIS 2012 I am trying to use a sensitive project parameter for an OLEDB connection for oracle.
It works perfectly with the Sensitive property set to FALSE (in Project Params Designer). But I do ...
Guglielmo asked 5/2, 2015 at 7:25
1 Next >
© 2022 - 2024 — McMap. All rights reserved.