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 |
|
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." |
|
|
|
|
|