![]() My SQL task will use this existing connection. I have already added an ADO.NET connection to my database. Add a new Execute SQL task to your workflow. Our first SSIS step is to create a new record in this table and save the ID. add int not null - Add BatchId column to Address. ![]() Batch where BatchId = scope_identity () commit transaction end - Add BatchId column to Person. Batch ( StartTime, Filename ) values ( startTime, filename ) select top ( 1 ) BatchId, StartTime, Filename from dbo. startTime datetimeoffset = null, filename varchar ( 200 ) = null as begin begin transaction insert into dbo. ( int not null identity ( 1, 1 ), datetimeoffset null, varchar ( 200 ) null, constraint primary key clustered ( BatchId ) ) - Create a new stored procedure for creating a new batch entry.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |