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.
| Author |
Topic |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2008-05-23 : 19:49:59
|
| Hi,I was able to successfully add an "Execute 2000 DTS pakage" object in SSIS. I was also able to go into its configuration and locate the 2000 DTS package on the target server. However, when I execute the package, it fails. Do I need to install anything on my server that has sql server 2005?thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-23 : 23:11:39
|
| Why don't run dts package directly in sql2k5? |
 |
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2008-05-27 : 11:32:24
|
| There are 2 servers involved. One with SQL 2000 and the other with SQL 2005. On the SQL 2005 server, I extract data in text files and ftp'd them to the other server. The server with SQL 2000 has a dts package which grabs these text files and imports them into tables. Currently the dts package is setup so that it fires after an hour after the the files have been ftp'd over. What I was hoping to do was to add the "Execute 2000 dts package" into the DTS that I am running in SQL 2005. So after the "FTP" it would fire the package right away, instead of waiting.Thanks, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 00:11:46
|
| You can enable package logging to find out why it failed. |
|
|
|
|
|
|
RUN DTS 2000 in SSIS