Here is some vb script that looks at the file attributes. The DTS can then dynamically see if the file is new. A suggestion is to create a global variable...

The column names are stored in the syscolumns table in the Master Database.

But it is safer to use sp_columns 'tablename' to view the column names in a table.

If it aint...

Hi,

I have to load the SQLNet Oracle client on the Server. There is no other way.

If it aint broke don't fix it!

I will let you know what the outcome is. The hardware has been ordered and we will test on the new partition. I was on a ado.net training course last...

Hi

Thanks for u'r feedback. We have also come up with this as a possible solution and we are going to test the feasibility.

Hi,

Try giving the Server a fully qualified name.

eg. SERVERNAME.COMPANY.com

Hi,

In Query Analyzer show the Object Browser go the the stored procedures and right click on the proc you wan't to debug. Debug is the last option in the list.

Cheers...

Hi

This should help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_sec_09dl.asp