question

ecomma avatar image
ecomma asked

Is it posible to using storeprocedure run sqlsever import export to get data

I have Application on the cloud. Another application on my server need data from the cloud. I use Sqlserver import export to get weekly records from the cloud to my server. I want to Create a Storedprocedure to run this on schedule basis.If posible pls give sample or links
sql-server-2008stored-proceduresimport-data
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Have you used SSIS before, as a SSIS package will handle the import/export and then you can schedule the package using the sql agent.
0 Likes 0 ·

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
As sp_lock mentioned. You should have an option to create an SSIS package after running through the Import/Export Wizard. Create that package and using SQL Agent schedule the SSIS package to run.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thank @AJ Mendo.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.