February 26, 2008 at 7:11 am
Hi
I just created a simple package that copy objects and data from SQL 2005 to SQL 2000. I used a Transfer SQL Server Object Task.
I'm copying 89 tables,index,primary keys and foreignkeys and data.
I'm getting an error
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Either the object or one of its properties is not supported on the target server version.".
Can you please help I'm new in SSIS. I need to move data to my reporting server running SQL Server 2000 from Live SQL Server 2005.
February 26, 2008 at 7:40 am
That one is pretty simple. You're trying to create something on the 2000 db that 2000 doesn't support. It could be a data type of a column or a schema or a piece of T-SQL code that is only good for 2005.
The only good way to do this is look at the log of SSIS and see if you can determine what table / object the error occurred on. Then investigate the object to see what "2005 only" property it has.
February 26, 2008 at 8:02 am
Sorry I'm new in SSIS I've looked for log cann't find one how do I locate one.
Thanks for the information you provided.
February 26, 2008 at 8:37 am
The easiest way to find errors is while you're in BIDS. When you execute a package in BIDS, it throws you into Debug Mode. When you're in Debug mode, or right after you exit Debug mode, look at the tabs on the top of the package and click "Progress" ("Execution Results" if you've exited Debug mode). This will give you a list of all the tasks that completed or failed, the order they happened in and any error messages.
To get an SSIS log, though, that you can see inside or outside of BIDs, right click a blank spot in Control Flow and choose Logging. Books Online can give you more details about the different types of logging in SSIS.
Additionally, if you're running the package via a job, you can use an Operating System command to run the package command line, then choose "Advanced" for the step and log the results to a text file.
There might be other ways of finding this information, but I find these are the most common. How did you create this SSIS package? Did you use the wizard or BIDS?
February 26, 2008 at 8:43 am
Thankx a lot Brandie
February 27, 2008 at 4:27 am
Brandie
I was using desing IDE. I've just use a wizard its worked fine except that its didn't copy the index.
February 27, 2008 at 4:32 am
You're saying you got it to work finally?
February 27, 2008 at 4:48 am
Yes but not happy. Because I used a wizard. I'm trying to make my designed package working.
Any ideas of how can I copy data from 120 tables (live system) and insert it to the tables that I've just copied.
I need to compare existing data and live and then insert the one that doesn't exist. I'm worried about perfomance on the live cause I have to extract every 15min.
February 27, 2008 at 5:56 am
Have you looked into transactional replication?
There's also database mirroring that might help you.
February 27, 2008 at 6:40 am
Thanks Brandia
I have decided to use replication. Good new I did manage to get SSIS working.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply