Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Appending option in transformation
Wendy the answer to your first question, You will duplicate the rows when you append. A response to the second part. When you say the jobs don't run successfully. What do you mean? Is there an error message? It also sounds like you are dropping the table and recreating each time you run...- jweber9
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
How to run a DTS when I want to?
I have this setup as a job that checks for a file every 15 minutes to see if a file exists on the server. If it exists then I execute another job. Function Main() Dim fso Dim filetogo dim oJobServer dim oSQLServer filetogo = "File name to be found" Set fso =...- jweber9
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
How can I automate to run DTS right after replication?
You could add another step in the replication job as the last step. Then when replication is done you could execute the DTS package. The step would need to be an ActiveX Script type and the language would be vbscript. Below is an example: Function Main() dim oDTS dim sServer dim sUser...- jweber9
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS package problem
How are you doing the email?- jweber9
- Post #4
- Forum: Microsoft SQL Server: Programming
-
DTS package problem
When you say you are running the package are you running it from a job or how?- jweber9
- Post #2
- Forum: Microsoft SQL Server: Programming
