I have a DTS package, which has some tasks. Each task is suppose to copy the data from an excel sheet to a table in the database. In case we encounter any error in the execution of any step all the data copied in the previous tasks in already populated. We want to commit the changes only when...
During a transformation I need to insert a unique identifier into a column of the destination table.
Everytime I insert a new record, I need to generate a unique code. How can I do it?
I tried to use the DTSLookups function, but I've got this error:
Error Source: Microsoft Data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.