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
 Import/Export (DTS) and Replication (2000)
 DTS quits without warning

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-08 : 09:05:47
Alex writes "I have a problem with DTS 2000 abnormal termination while editing a package. I am trying to set SQL query with parameters as a source of DTS Transformation Task. I have pre-built and debugged in Query Analyzer. All I am doing is loading the query from the file and changing hard coded values to parameters (?).
I've done one of them already successfully, and was able to parse and set parameters. But second one, while seem to be the same as far as type and structure is giving me problems. Every time I change hard coded values to ? and click Parse, OK or Parameters DTS and Enterprise Manager quit without any warnings or error messages. I use union queries in both cases in the same package but only one causing problems. What gives?
Thank you in advance."
   

- Advertisement -