I'm loading a ssis package from my application which works fine. However, what I'm trying to work out and failing miserably is that the package executes in 1 second (which is great) but the loading...

I'm working on an SSIS ELT script that needs to parse dates from a TSV file that are stored in the format [INTEGER].[INTEGER] (Excel integer dates followed by second since midnight, e.g., 42825.940...

I am using SSIS in VS 2013. I need to get a list of IDs from 1 database, and with that list of IDs, I want to query another database, ie SELECT ... from MySecondDB WHERE ID IN ({list of IDs from My...

Is there a way or query by which I can find the version number of SSIS packages (*.dtsx files)? I have the *.dtsx files in my Team Foundation Server for which I wanted to know. The manual way is ...

I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has driven me nuts because I don't know how to separate the statements: @[Use...

In Script Component [Input0_ProcessInputRow], i am trying to fetch "ReadWrite" global variable value and it throws below error. ERROR: The collection of variables locked for read and write acce...

I am using FlatFile Source Manager --> Script COmponent as Trans --> OLEDB destination in my data flow. Source reads all the rows from flat file and i want to skip the last row (Trailer record) up...

Does anyone know of a chart that shows which formats of dates are supported by the different datatypes in SSIS? For example, does DT_DBTimestamp support the format 1-Jan. I tried looking but couldn...

I created a SSIS Package in Visual Studio SSDT 2012, using Package Deployment model. Is there any way to get access to the package's file name as a readonly variable or property from within the pac...

I have a ssis project in which the master package contains many child packages. All the child package are invoked with execute package task. I need to pass the "begin date" value from master to all...

What exactly is the use of Miscellaneous folder in the SSIS Solution folder hierarchy? I have use many packages and solutions as a part of the project,but never used this folder.I do understand tha...

i was querying the ssis catlog to find out the name of all the packages in the catalog. There are only 6 packages in the Folder1 project,but the query gives 9 records 1. SELECT P.NAME FROM SSISDB...

Any help is much appreciated. I am trying to create an SSIS package to loop through files in the folder and get the Path + filename and finally execute the stored proc with parameter as path+filena...

I created a SSIS to export to a csv file I don't wan't my SSIS to create an empty file if there is no data. How can I achieve this ? Thanks,

I am building a conditional split in SSIS to figure out if a row is new or updated. One of the columns I want to compare is a guid and it allows null. I tried to compare the column like COLUMN !=...

During the insert into a destination table, any error that occurs is redirected to Errors table where we can see the ErrorCode and ErrorColumn. The problem is that we got a value in ErrorColumn whi...

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a DBF file using the VFPOLEDB provider, and puts it into a database on a SQL Server 2012 X6...

First, I'm loving the very clearly delineated versioning of the SSIS tools. >:( I installed SSDT BI for Visual Studio 2013 and built a nice little project in it to generate test data. Within VS 20...

I have a package that is developed in SSIS 2012 using Visual Studio 2010. Is it possible to deploy/attach this package on SQL Server 2008 If it is possible, does the licence of the sql server m...