If you run as a scheduled job, it's running on the server, in which case you need to have EXcel installed on the server. When you run the DTS paclage...

We had this problem, but didn't want the hassel of evaluating the impact of changing  the schema so decided just to cast when joining.

e.g. If DatabaseA contains TableA, and DatabaseB...

I had this problem...you can only design ER diagrams in professional(really helpful!!!), you need to upgrade to enterprise architect(EA) version.  This is also possible by installing EA version of .net...

Hi,

Have you tried looking in event viewer in case it is an automation failure earlier on. Although I can't imagine that being the case if it works most of the...

We have found need to do this quite often so we capsulated the logic in a function. This was your code stays nice and concise and the logic can be...

We have many similar situations where we need to read in a file with variable length records and then write them to many different tables.

We have used the data...

Guys,

Thanks for the help. Much Appreciated.

I'm sure you've rebooted the box since installing the db drivers. If you haven't it's worth ago.

We had a similar problem with oracle drivers and a reboot did the...

I agree the FTP tool in DTS is very weak.

I have overcome this by wrapping the ftp functionality exposed in wininet.dll(a dll deployed with windows) in a COM object using...