19 I am using Execute Process task in SSIS 2008 R2. I have a variable idVar which is of data type Int32. I need to pass this variable to property Arguments of the task so the process executable …

SSIS Performance Framework Plus, you don't have to do any custom work or maintenance on your stuff. Out of the box functionality is a definite win. That said, you aren't really going to …

I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go …

Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); …

Have a pretty straight forward SSIS package: OLE DB Source to get data via a view, (all string columns in db table nvarchar or nchar). Derived Column to format existing date and add it on …

I am redirecting rows from a flat file source to a flat file destination. The default metadata in the redirected rows are: The original flat file source row The ErrorCode The ErrorColumn What I …

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 …

SSIS expression: convert date to string Asked 12 years, 6 months ago Modified 1 year, 8 months ago Viewed 169k times

When Connecting up the network drive where the file was located (H:), I did not check the Connection string and what level that the file was grabbing it from in SSIS.

I need to allow a consultant to connect to SSIS on a SQL Server 2008 box without making him a local administrator. If I add him to the local administrators group, he can connect to SSIS just …