All you need is the bids helper (free download from codeplex)

http://bidshelper.codeplex.com/Wiki/View.aspx?title=SSIS%20Performance%20Visualization

Try this: in the script code, throw an exception, handle it gracefully\mask it in the OnError.

There you have it.

Have you tried using the data type conversion in SSIS to convert from unicode to ansi? Is the problem an incorrect conversion? or SSIS not loading the source as it...

Use the event handler OnError and in there have your Source Excel and Error Output connection mapped. That should do it.

Can you write a function in SQL that takes string as input and outputs date and then apply that function in the select of your source.... - a solution. (may...

If you need a 'Real Good' provider, there is one - Ritmo provider (ADO.NET) performs 3 times faster than a oledb provider. I tested it in our environment and works...

I also had a similar problem. But after a while the packages started erroring out. Turns out you need the MSDTC service on the same machine where the packages are...

The Data flow task in SSIS will do a INSERT BULK statement. I would follow pradeep's advice on the recovery model. Just optimize the options in the destinaion adapter: maximum...

Is your xml config file referenced as an indirect configuration thru environment variable?

sorry, wrong post.

Have u tried changing the metadata in the flow?

Do u mean like an execute SQL task creating the temp table and then the OLEDB source in a data flow task access it.... u can.

for the source to read...

Thanks, but i figured it out.

Can you ask the AS400 admin to transfer data into a file format, ship it in a DVD and then u use SSIS from there.

I used the ODBC provider for...

an easy debugging method (if u dont already know it)

Put a script task component between your Execute SQL Task and DataFlow Task and print the variables DBName, ServerName etc

Add the...