Can't seem to get SQL Server to import data ever

Todd C

2009-06-25 13:16:01 UTC

Hello Jonathan:
Yes, SQL 2005 and SSIS is a bit of a step up from SQL 2000 and DTS, but I
think once you get past the initial sharp learning curve, you might not be so
frustrated.

Try this: Right click on a Database node and select Import or Export Data.
Follow along throught he wizard. When you are finished, have it save the
resulting SSIS package to your file system then open it in BIDS to see what
is going on.

Just because you don't have the two servers linked doesn't mean you can't
use both of them in one ssis package to move data.

HTH
=====
Todd C

Post by Jonathan Crawford
Hi
I confess I pretty much hate SQL Server 2005 now
DTS tasks which were absolutely trivial in 2000 now have become nightmares.
I create scripts for the tables
I export the data to an access database
I run the create table scripts on the new server
I try and import the data and always get ludicrously unhelpful error
messages like this
I want to move data from one SQL Server 2005 to the other. I don't have
connectivity between them
Error 0xc004701a: Data Flow Task: component "Destination - XXX" (22) failed
the pre-execute phase and returned error code 0xC0202025.
The table in question has one into column and one nvarchar colum. Identity
insert it set to enable.
If it remove this tabler from the list then it just errors on the next.
Why does it do this?
thanks
jc
===============
Jonathan Crawford
===============