question

kumarm11 avatar image
kumarm11 asked

How can we update 10 tables by comparing with a text file using packages in ssis 2008?

Hi, I have 10 tables each corresponding to patients list in each ward in a hospital with column names patient name and status At the end of each day a text file with details regarding the patients who got discharged on that day is produced We have to compare the patients list in this 10 tables with text file one by one and the status of the patients who got discharged on that day have to be changed to discharged How can we implement this using packages in ssis 2008 Waiting for quick reply Thanks in advance.
ssispackagelookupsforeach-loop
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
If I were you I would try to import the text file into a table. Then by adding proper indexes on that table, it would be much easier and more optimized task to compare and update the tables as per requirement. Hope it helps.
11 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
you can create a bare-bones SSIS package for your file by right clicking on your database the selecting Tasks > Import Data... You can let the package create a new table for you. Once the file is loaded into its table, you can use TSQL to do the status update
2 Likes 2 ·
Usman Butt avatar image Usman Butt commented ·
Its quite easy if you know SSIS, as it is very flexible. I would rather suggest that you learn SSIS by creating some packages in test environment. Then, we would definitely help once you let us know how are you implementing it in the SSIS package and what part is not implementable for you. I hope you do understand that it is for your good.
1 Like 1 ·
KenJ avatar image KenJ commented ·
You could get started learning about SSIS by going through the "Stairway to SSIS" series - http://www.sqlservercentral.com/stairway/72494/
1 Like 1 ·
kumarm11 avatar image kumarm11 commented ·
hi thanks can you expalin me clearly what type of transformations can i use in this?
0 Likes 0 ·
kumarm11 avatar image kumarm11 commented ·
as i am new to ssis can you explain me detail?
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.