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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2014-03-03 : 05:42:45
|
| hi,we need to copy the excel/Txt filesfrom network location commondrive(foder to )to server folder.After that using sql server 2008 to pull thIs there any way to do that using ssis tasks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-03-03 : 06:00:38
|
| yep..You can use File System Task with Move file operation to move files from one folder to otherThen you can use data flow task to extract data from file to sql table. Use excel source for excel or flat file source for text file and use OLEDB destination for inserting to sql server table.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2014-03-03 : 07:06:29
|
| Thanks vishak for your guidelines.and pls Explain me the required options and building method for using Filesystemtask in ssis to do the same |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
sql server2008 using ssis for files load