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.

more ▼

asked Mar 09, 2013 at 04:26 AM in Default

avatar image

30 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Mar 09, 2013 at 01:23 PM

avatar image

Usman Butt
13.9k 6 13 21

hi thanks can you expalin me clearly what type of transformations can i use in this?

Mar 09, 2013 at 06:06 PM kumarm11

as i am new to ssis can you explain me detail?

Mar 09, 2013 at 06:41 PM kumarm11

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

Mar 09, 2013 at 07:06 PM KenJ

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.

Mar 12, 2013 at 02:49 PM Usman Butt

You could get started learning about SSIS by going through the "Stairway to SSIS" series - http://www.sqlservercentral.com/stairway/72494/

Mar 13, 2013 at 12:41 PM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 09, 2013 at 04:26 AM

Seen: 1448 times

Last Updated: Mar 13, 2013 at 12:41 PM

Copyright 2017 Redgate Software. Privacy Policy