I want to capture who is running the package in the variable.

Thanks

use zipstream to unzip in a scrip task then I would use for each loop and enumerate with a file wildcard like tt*.*

Use a varaible where i put the...

I need help with the transformation script that will parse each row and count the number of commas (probably with a script). After it gets to the 25th comma...

Could you help me with the script?

I understand. Try this.

Use a valid Windows login to connect to SQL Server. If you must continue to use a SQL Server login, you can change the security authentication...

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"

to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

http://support.microsoft.com/kb/555332