I have two connections, an oracle and sqlserver. the dtspump task is pulling data from oracle to sqlserver. I am trying to automate this package by substituting the where clause values to variables since they are based on year and month. My question is - how does one use global variables in a dtspump task? How can I use variables to do this? Can it be done or do I need to use an Active X script for it?
thanks for any help.
novice userMay check with SQL DTS (http://www.sqldts.com) website.
Showing posts with label pulling. Show all posts
Showing posts with label pulling. Show all posts
Subscribe to:
Posts (Atom)