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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 7 DTS

Author  Topic 

lba
Starting Member

3 Posts

Posted - 2003-01-07 : 08:29:21
I am trying to analyze a dts package set up on sql 7 in 1999. I can see the graphical image but when I click on the "pump" properties an error is returned. I am trying to figure out exactly what it is doing. It is bringing a file from another server/pc and I want to know the format of the file. Can any one help me to break down the package.
Thanks

Louise

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-07 : 08:33:04
Why don't you start by sharing the error message...

Jay White
{0}
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2003-01-07 : 10:52:18
To open the graphical bit and see the properties you will have to have the objects for it to connect to.

Alternatively you can look at the object properties in the package - this is easiest from a VB app.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -