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 |
|
nsithole
Starting Member
9 Posts |
 Posted - 2013-10-19 : 19:48:45
|
| n |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-20 : 03:20:29
|
to import data to table inside execute sql task just use query likeINSERT StagingTableSELECT *FROM SourceTable to insert from Excel you need to use distributed query methods like OPENROWSET the error looks like you dont have stored procedure created in the database used in connection or you're using wrong connection parameters------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Execute SQL Task