I can't explain the message "The system cannot find the file specified", but if the WindowStyle property solves the problem, I guess there is a relation between this property and...

You should set ResultSet to Single Row (as your query only returns a single count). In addition, alias the count(*) in your query, i.e. SELECT COUNT(*) AS JMCnt FROM .......

Add the two tasks to your control flow. Connect the two tasks to your initial step that initializes the variable. Now you can add a precedence constraint on both connections...

I intuitively choose 2 because 1 and 3 are definitely wrong. 1 doesn't take care of month and day of birth at all and 3 does it in the wrong...

Check out the following article:

http://www.sqlservercentral.com/articles/Integration+Services/61824

It describes the same problem but then occuring in SSIS.

Peter

To avoid problems when forgetting to remove the MessageBox.Show code after debugging is complete, you can write your own debug function which calls Message.Show after checking the variable System::InteractiveMode.

Peter

I guess the problem is that the child packages don't know where to look for the configuration file. If you run a parent package either in SQL Agent or by...

Just some thoughts. Does the fileLoc contains a terminating slash? Otherwise try File.Exists(fileLoc + "\" + fileName). Does fileLoc contains a drive letter? Maybe something is wrong with your (network)...

BTW, try using other Data Flow Transformation before using the Script transformations. You can use the Conditional Split Transformation to filter out unwanted data, use Derived Column Transformation to compute...

You can use a Foreach Loop Container for this task. On the Collection tab set the enumerator to Foreach File enumerator. Set Folder to your common parent folder, Files to...

If your database also contains a time dimension with a Date column, you can use a query like the following as the lookup table:

SELECT

E.ID, E.EMP_ID, P.DATE AS...

I am not very familiar with SMO, but I remember I wrote an application using DMO (the ancestor of SMO) a couple of years ago with a drop down box...

What do you mean by 'bat file will not execute sql agent job'? Is the destination folder created? I don't known exactly what's the current directory when Sql Agent runs,...

Check the 'Keep Identity' checkbox off in the Destination Editor (it's the FastLoadKeepIdentity property in the Properties box, which must be false).

Peter

Well if the "Suggest Types..." doesn't give you what you want, you can edit multiple columns at once on the Columns panel of the flat file connection manager. Select all...