SSIS 2012 is Microsoft SQL Server Integration Services 2012, and is part of SQL Server 2012. SSIS allows SQL Server to interact with other technologies, including import and export of data to and from other formats, or ETL, and data warehousing.

learn more… | top users | synonyms

0
votes
1answer
22 views

How to Implement a Retry Feature in SSIS 2012 When a Database Connection Fails?

We have an SSIS 2012 package that supports our internal analytics reporting database by extracting data from an external database server. Last night, for the first time, the package failed due to a ...
1
vote
1answer
22 views

How to deal with multiple error columns in data flow

I'm writing a simple package to load data into tables and a I have multiple destinations within the same package. I'm attempting to first attempt batch inserts but want to fall back to row by row in ...
0
votes
0answers
29 views

ssis ado.net destination has failed to acquire the connection

I am Transferring data from sql server source db to sql server destination db (cross db). but some times getting error "ssis ado.net destination has failed to acquire the connection.The connection may ...
0
votes
0answers
38 views

SSIS and Script Component - WebReference problem

Within my SSIS package-dataflow I have a script component and within this component whenever I add a Web reference and close editor, script component gives me "Validation error. Data Flow Task ...
0
votes
2answers
30 views

SSIS and Excel import

I am using VS2012 and creating a package on a 64bit machine to import some data from a .xlsx file. My question is that I am getting an error for the Excel connection manager, do I need to install ...
0
votes
1answer
46 views

How can I get more information about which lookup failed in an SSIS lookup?

I'm frequently getting errors along the lines of Error: 0xC020901E at Build Test Data, Lookup ID String[120]: Row yielded no match during lookup. To resolve these, I'm going back to the source and ...
0
votes
1answer
54 views

Why Does SSIS Oracle Source by Attunity return DT_WSTR for Oracle CHAR(1) Column?

Using SSIS 2012 and Microsoft SSIS Connector for Oracle by Attunity v. 2.0. When I add an Oracle Source for a particular table, it is setting the data type for an Oracle CHAR(1) field to DT_WSTR. I ...
0
votes
1answer
56 views

VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component ", clsid {4CAC … Could not be created

I am creating my first SSIS package to support the E of our ETL from an external Oracle database to our internal SQL Server 2012 databse. Using Visual Studio 2012 and I have installed the Microsoft ...
3
votes
0answers
97 views

How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?

There are several blogs which claim to categorize SSIS Transforms into blocking (asynchronous), non-blocking(synchronous) and partially blocking(asynchronous). When looking into the specific ...
1
vote
1answer
149 views

Package deployed in SSIS 2012 catalog fails with timeout error

I created an SSIS package in Visual Studio 2008 and deployed it to SQL Server 2012 by using Integration Services Catalogs. When I run the package from BIDS it completes successfully. When I schedule ...
0
votes
0answers
22 views

Copy SSIS 2012 Report Text to Clipboard?

When I run a SSIS 2012 report to view the errors, I note I can't select any text to copy to clipboard. Is there a way to get raw error text? (It seems you can right-click and export to ...
1
vote
0answers
98 views

CDC with SSIS: process all changes in order of occurrence

I have a SSIS package that I'm using to sync (in an on going basis) all changes from one table to another. Note that I need to sync ALL changes and not just NET changes. My problem is that I cannot ...
2
votes
0answers
112 views

How do I map SSIS 2012 Package Variables to Parameters?

I have created multiple packages that use variables to assign Connection Manager Expressions such as Connection String. However in the new SQL 2012 Project Deployment Model I don't seem to be able to ...
1
vote
1answer
209 views

SSIS execute task running wscript.exe hangs when started from SQL Server Agent

I have a problem with sql server 2012 SSIS package which has execute step running wscript.exe utility. When I run this package from BIDS everything works fine, when I start package from SSIS it also ...
4
votes
1answer
186 views

Why is SSIS slow to enumerate over many files in a directory and import them?

I have a terribly slow SSIS package. It's quite fast with one file, and reasonably fast with 100 files or fewer. (About one second per file) However, if my directory has thousands of (very small) ...
2
votes
1answer
97 views

SSIS Memory allocation

Is SSIS subject to the maximum memory limitations for SQL Server 2012 Standard edition? If I have a server with 128GB RAM and I allocate 64GB of RAM to SQL Server does SSIS utilise this memory or ...
0
votes
1answer
56 views

Namespacing database names on my server in order to test multiple different SSIS packages

An SSIS package that I'm building has two OLE DB connections, to databases named "core" and "staging". I created test versions of these two databases on my local SQL Server installation. I named them ...
0
votes
0answers
208 views

SSIS package starts and stops immediately with a DTS_W_MAXIMUMERRORCOUNTREACHED, but there's no error to read

I have a package that, when I run it in Development mode, it outputs the following into "Execution Results": Import Validation has started Validation has ended Start, 10:36:27 PM ...
4
votes
0answers
163 views

DTUTIL performance slower in SQL Server 2012?

We've noticed that since deploying Windows 2012/SQL Server 2012, the performance of DTUTIL has decreased. DTUTIL.exe consumes 50% on each of 2 cores on an 8 GB VM. The same syntax against Win 2008 ...
1
vote
1answer
272 views

SSIS 2012 Ftp parallel/asynchronous multiple file download

Any help would be appreciated with either scenario. if Are there any settings available to download multiple files in parallel from an FTP server? else If not, I guess I'll just roll my own via ...
0
votes
0answers
52 views

connection string and variables shared for different projects using ssis 2012

I am using ssis 2012 . I have four projects which share 3 dynamic connection string and 2 variables . I have also two different environment : Production and Test. I have to repeat the configuration ...
-1
votes
1answer
47 views

SSDT/SSIS 2012 - How to automatically load some projects?

I did not use the default projects folder in SSDT, ie SSIS 2012. I used my own instead. Every time I open SSIS, I have to load the projects manually. Is there any way I can load them automatically ?
0
votes
1answer
33 views

how to downgrade an unknown (2005) interface name from SSIS 12 to 05

The namespace Microsoft.SqlServer.Dts.Runtime.Wrapper was research, but a suitable SSIS 2005 counterpart to a SSIS 2012 interface named IDTSConnectionManager100 was not found. Any help for the ...
0
votes
1answer
46 views

how to downgrade a statement for SSIS

Following snippet works within SSIS 2012 --- derive colum block. TOKEN(REPLACE(@[User::FileName],".csv",""),"\\",TOKENCOUNT(REPLACE(@[User::FileName],".csv",""),"\\")) But it does not work within ...
1
vote
0answers
55 views

Displaying SSIS variabe values in Integration Services Dashboard

I have an SSIS package that executes stored procedures which return output parameters into ssis variables. How can I easily display these variables content in the Integration Services Dashboard ? ...
2
votes
3answers
1k views

Error: “To run a ssis package outside of sql server data tools you must install send successful email of Integration Services or higher.”

Version SSIS 2012. Package was originally 2005 ver. Package on file system. DB Engine / Agent on Host 1, SSIS on Host 2. Execution from Host 2 runs successfully. Execution from Host 1 gives the ...