Hi,

You can use environment variables to hold the connection string to fix the issue.

Please find the details here with an illustrated example http://www.mssqltips.com/tip.asp?tip=1405

Hi,

This is the information which we can get from the SQL Server Books Online.

Indicates whether the specified SQL statement to be run is a stored procedure. This property is read/write...

Hi

You can use a for each loop container to loop through the files in a folder.

Everytime one single file is taken based on the enumerator configuration of the for each...

Hi ,

The error usually occurs when the flat file source has data conversion issues.

Please check for the data types which you are using in the flat file and see if...

Hey you can use the date add function to increment minutes...

the syntax is dateadd(minute,"number by which you want to increment","which you want to increment")

use this date add and produce...