a question about IMPORT/EXPORT from the SQL 2005 Migration

5 pts.
Tags:
SQL 2005
sql 2005 Migration
In our original SQL 2000 DTS jobs, we call Stored Procedures and run BCP commands to Import/Export clients files. In our new environment we can not have the Admin right and permission for BCP. We tried to use BULK INSERT login from a special SSIS login name, but that login name is not our regular networking login name (we can not add this one to the networking) so we did not get the access for Import/Export files.

I know we can use SSIS TRANSFORM, but I need to "chop" Stored Procedures to pieces (between data manipulations) to insert the SSIS TRANSFORM task, we are talking about 400 hundreds Stored Procedures. It sounds crazy.

Do we have any other choices ?

Thank you so much.

 

 



Software/Hardware used:
SQl 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

Not really, that’s pretty much your option.

For importing data use the BULK INSERT command from a login which is a member of the bulkadmin fixed server role.

As for exporting data that’ll need to be done via SSIS which will require that you break apart the stored procedures.

The easiest solution isn’t always the correct solution, and the correct solution isn’t always easy.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following