If so are there any tutorials on this?
I'd prefer not to do this by hand. ;-)Just use DTS graphic wizard.
BOL is the best tutorial|||Try the wizard in Enterprise Manager. That's a nice easy intro into it.|||I have a simple package where I want to dump data from one table to another. Its erroring out on this line.
DTSDestination("TaxExempt") =1
The destination field is int.
I don't receive any errors when i have the following:
DTSDestination("ShippingWeight") = DTSSource("weight")
for some reason it doesnt like the hardcoded value i supplied it.
Any ideas why?
Thanks for the help.
