Controlling the flow of executon while execting a package

  • Hi

    I have quite a few files(.txt) to be loaded on to a database. I want to use the same sql server connection for each file, but i have to load the files keeping the foreign key relation ships in mind.. so i need to have the workflow directions mantained.. how can we achieve this if i have a just one sql server connection.. please let me know.. also please let me know what other way would you have done if you had to...

     

    Thanks

    THNQdigital

  • I assume you want to load all the files in a single package.  You can create 'on success' or 'on completion' workflows between each transformation task.   They would point from the SQL Server connection icon to each text file connection icon.  Edit each workflow and choose the source step.

    If it makes it visually easier, you can copy the SQL Server connection icon by right-clicking and choosing 'copy', then right-clicking in a blank area and choosing paste.  

    Hope this helps.

    Greg 

      

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply