July 18, 2012 at 12:54 am
Please help!
There will be csv file from SQL Server of the contractor will send to me new reading every 10 minutes.
How do I insert this csv file into my SQL Server 2005 every 10 minutes?
Thanks!
July 18, 2012 at 1:01 am
You might need a SSIS / BULK INSERT / BCP scheduled job. Opt as per your convenience.
July 18, 2012 at 1:13 am
July 18, 2012 at 8:30 pm
Thank you very much for your help!
I do not know how to create the SSIS Package (SSIS / BULK INSERT / BCP).
If possible can you show me how? Thanks
July 18, 2012 at 8:39 pm
are you familiar with BIDS via MS Visual Studio? this comes installed with the SSMS when you select the BI Development studio during your SQL server installation.
heres a link that features the step by step tutorial on creating a simple SSIS project and task. i found these to be helpful, hopefully it will be the same to you.
July 18, 2012 at 8:40 pm
i forgot to paste the link! http://www.mssqltips.com/sqlservertutorial/205/creating-projects-and-solutions-with-ssis/ 🙂 🙂 🙂
July 20, 2012 at 1:07 am
July 21, 2012 at 8:56 am
duc.nguyen (7/18/2012)
Thank you very much for your help!I do not know how to create the SSIS Package (SSIS / BULK INSERT / BCP).
If possible can you show me how? Thanks
Stairway to Integration Services
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply