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.
February 15, 2010 4:58 PM
February 16, 2010 3:36 PM