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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to rollback the tasks into a package
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...- garpale
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
-
How can I insert a sequence id into a table
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...- garpale
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
