ssis go thru direc get file name and give it to sp

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 2008 Forums

SSIS and Import/Export (2008)

ssis go thru direc get file name and give it to sp

Author

Topic

Nader
Starting Member

41 Posts

Posted - 2010-05-04 : 22:31:17

SSIS - go thru files in a directory-get file name provide it as argument to stored procedure then get next file nameQuestion:
I would like to create an SSIS package.
That looks in a directory say c:\data
this directory has a lot of xml files say file1.xml, file2.xml, etc.
picks the name of the first file provide it as an argument to the stored procedure say usp_process (filename) run the stored procedure then goes to the next file

Thanks in advance

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 02:53:15

given here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=143814

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Nader
Starting Member

41 Posts

Posted - 2010-05-11 : 01:14:06

Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources