Create a Data flow in SSIS wich updates som rows.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create a Data flow in SSIS wich updates som rows.

Author

Topic

t_granat
Starting Member

3 Posts

Posted - 2006-08-14 : 23:03:53

Hi,

I have a table customer wich has the columns phone_number(char type) and ok_to_call(bit type). There are already data in the table and the column ok_to_call only contains the value false for every row.

Now i want to update the latter column. I have a text file with a list of phone numbers and i want that all the rows in the Customer table(phone_number column)that matches the number in the text file to update ok_to_call to true.

This is to be done in SSIS(Integration Services). I'm new at this and i've looked around that tool but is a lot of items, packages and stuff so i dont know where to begin.

Would appreciate help on how to solve this issue in SSIS. What controlflow/Data flows to use,wich items and packages to use, how to configure and how to link together?

Regards
/Tomas

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-15 : 03:15:08

Wouldn't it be easy enough to use OPENROWSET and update directly?

UPDATE		Customer
SET		ok_to_call = 1
FROM		Customer
INNER JOIN	OPENROWSET(...) f ON f.SomeCol = Customer.phone_number

Peter Larsson
Helsingborg, Sweden

t_granat
Starting Member

3 Posts

Posted - 2006-08-15 : 16:37:29

It's a school assignment and it says that this is to be done by using SSIS. Any suggestion on how to solve it then?

But with your sql code, how do you write code to get the phonenumbers from my text file numbers.txt?

Tomas

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-08-16 : 05:23:29

"It's a school assignment "...at least you're honest in this regard.

However....you'll get more brownie points from the teacher/lecturer if you consult them on the problems you are having in attempting to solve this problem, than if you turn up with the answer but no nothing about why the answer works.

Also....our appetite for solving "homework" is VERY limited.

1 hint...start doing something simple with SSIS....and then work upwards to solving the problem. The point of the problem isn't really for your to solve the stated problem...it's to train you to 'experiment & learn from the results'.
...and there's not much point in us doing the experimentation for you...we're already qualified!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources