why r u copying, why can't u just take backup of that database and restore to ur SQL2005 instant, that way u will not miss anything. Tables or views or...

Increase the timeout period under tools , Advanced settings and then u try increasing timeout under Rt.clk on server ->properties ->connections->query time out from 600 secs to more.

sorry i had used tags before

you can use DTutil /S "--your server name--" /E /N "--your package name--" /W "0"

you can use DTutil /S " " /W "0"

May be u r comying table into a different database and looking ur results in some other database.

One bad way would be to set 'ignore error' for that column. And after the transformation, u can check that column value or set what u want.

You can just import ur flat file using import/export ssis wizard and then it will show u an option while ur using the wizard. when u reach to a point...

If you are referring special characters such as universal code(unicode), then you will have to use nvarchar, or nchar which take twice the disk space as usual characters, non-unicode.

I am...

To Audit, you can use Sql servers C2 audit feature that will logon all failed and successful logins. To take this into affect you have to restart the server and...

But if u have saved the package as a file then it will store the location where you wanted the pacakge to be stored. In that case Security level of...

Few things that u can do now.

1) If its not a complicated package then design those two packages again and while designing before you save then be very careful...

one question, whats the default database for your user?Is it the same database you are trying to connect from your App?

Or you can use DTS or SSIS wizard to copy data from one database to another

sleeping means connection is still connected to sql server.ur conection from app has not been kicked. sleeping anyway will not contribute to blocking or locking cause it will not take...

R ur Protocols enabled(TCP/IP or named pipe)?