Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DTSRUN

Author  Topic 

TopsyKretts
Starting Member

6 Posts

Posted - 2008-02-04 : 11:17:55
Hello all,
I am trying to run a DTS package from a .DAT file and in my file this is my code:

DTSRun /S ServerName /E /N "Promo Point Adjust - Import promo file"/
But when I run that the data in the table is not being updated. my question is
-how to I step through the to see what the disconnect is?
-Or if there is an error that is happening but being displayied?

Can anyone help me

Hommer
Aged Yak Warrior

808 Posts

Posted - 2008-02-04 : 13:17:24
Well, I have seen many ways to run DTS (vb6, .net, cmd line, or even ASP), but I am not aware of the .DAT way. Even that is a viable way, the trouble you have run into, i.e. hard to debug, suggests you shall try some other ways.
Go to Top of Page
   

- Advertisement -