For pure data movement tasks, I agree that OLEDB connections are faster, but I have found the ADO.NET connection to be much easier to use for procedure calls. In...

As a side note, for viewing very large files, there is a shareware utility called "V" by Charles Prineas that I have used for years. I have never encountered...

For passing parameters to stored procedures, I use an ADO.NET connection manager, and create a package scope user variable that will hold the value to pass. Get the value...

If you have adequate permissions, you can use a UNC path to the executable such as:

Executable: \\MyServer\C$\SSIS_Projects\SomeExe.exe

I think that it indicates that a data row doesn't match the structure that a format file is expecting.

I don't know if you'll find exactly what you're looking for, but the SANS reading room section on disaster recovery may prove useful:

http://www.sans.org/reading_room/whitepapers/recovery/

You could try a capture at the OS level by appending a redirect on the command line in the batch file:

dtexec /File \\MyServer\MyDirectory\MySSIS_Pkg.dtsx > somelogfile.log

I have a problem with the pernicious brigands that will leave less than a cup of coffee in the pot, and then not make more.

I am in an...

Whenever I'm working with ASCII text files, I always use string data types regardless of what "type" the field is, whether date, numeric, etc, since as long as it's plain...

All of my ETL work is going in to SQL Server tables from various flat and CSV files, but a sample of one of my date format statements from a...

If you have OS access, you can copy and paste the solution folder in Windows Explorer. If you do so, you may need to update component GUIDs in the...

You can test column values with a conditional split data flow transformation. Based on the evaluation of your split condition, you can re-direct rows to another destination.

For example, the...

I don't know if it's applicable in your environment, but when I needed to create a CSV out file, I ended up keeping a static header file, writing out my...

I have only 3 hardcopy books in my overhead bin:

T-SQL Querying (2005 Ed) by Ben-Gan et al

SQL Server 7 Secrets by Rensin et al

A Guide to SQL by Philip Pratt...

Here are the actual execution plans.