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
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 pass data from file into SP

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2007-07-05 : 04:57:28
Hi,
Using SSIS 2005 how is it possible to loop through a folder on the network, look at each file, pass the data inside each file as a string into a stored procedure.
Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2007-07-05 : 06:05:00
Which bit are you having problems with?
see
http://www.simple-talk.com/sql/sql-server-2005/executing-ssis-packages-/

It includes how to loop through files in ssis


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2007-07-05 : 06:45:35
using SSIS I am not sure how to pass the data from each file into a stored procedure as a parameter
Go to Top of Page
   

- Advertisement -