May 10, 2007 at 1:58 pm
Hey, I am new to SQL server and SSIS. I am trying to build a SSIS package that exports a whole SQL 2005 database to an Access database in a dynamic fashion. I have used the wizard to copy some tables over, however when I select all the tables it fails (total tables in this case was 395), also I find the wizard to be limited for what I am trying to do. I am currently looking at building a package programatically, but am having little success so far. Just wondering if there is anyone who has done this before or if anyone knows of any helpful tips and tricks that can help me out. I appreciate all feedback.
Thanks
May 14, 2007 at 3:19 am
what is the error message that it gives you when it fails when doing the import using the wizard?
an alternative is to write your own application using c#, vb .net etc which uses SMO.
but probably the easiest soln would be for you to save the import wizard output as a package and then use the BI Studio to modify the code as appropriate
May 14, 2007 at 9:30 am
This is the error I am getting:
Could not connect destination component.
Error 0xc0204016: DTS.Pipeline: The "output column "users" (1328)" has a length that is not valid. The length must be between 0 and 4000.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0204016 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
It looks like it does not like that particular table. As for a solution, I have been modifying my import/export package that executed successfully using the script tasks to make it more robust, seems like I am on the right track for now, though I am still open to feedback and advice. I have also looked into writing my own package programatically using c# and vb.net. Thanks for the feedback.
May 14, 2007 at 10:20 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply