INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I train people in ACCESS. I make sure they know about these forums, give them some training on how to use the site, and have a shortcut to it on their PC's..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Integration Services (SSIS) Forum

Should SSIS be used for the following?

Read More Threads Like This One

jonwolds (Programmer)

12 Jul 06 5:33

Hi,

Can SSIS be used to implement the following:

1. Each company will supply a monthly text file.

2. A companys file format will be the same each month.

3. No two companies will use the same file format and column orders/number of columns as each other.

4. I want to poll a windows folder for the text files and import them into a staging table, ready for validation.

I can do this using a stored procedure by creating a format file for each client and storing the name of it in a table. The client name is included in the file name and this can be used to look up the appropriate format file from a table which is added dynamicaly to the Bulk Insert command.

Is it practical to create this solution in SSIS or am I better of sticking with stored procs?

Thanks

Jon

mrdenny (Programmer)

12 Jul 06 20:28

I would stick with the stored procs.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

jonwolds (Programmer)

13 Jul 06 6:54

Thanks for your response. Please could you elaborate?

Jon

mrdenny (Programmer)

13 Jul 06 14:03

Writting something this complex in SSIS will be tough to say the least. If the solution you have now is working and it's working correctly why change it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Integration Services (SSIS)