transfer sql server task is not working - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » transfer sql server task is not working

transfer sql server task is not working

Options

Previous Topic · Next Topic

dibyant

Posted: Saturday, February 02, 2008 10:24:07 PM

Rank: Newbie

Joined: 1/21/2008
Posts: 9
Points: -73
Location: usa

hi
Actually, i have installed both sql 2k and 2005 both server on the same computer and when i am using to
transfer sql server task to transfer the database objects from 2k to 2005 its executing successfully but its not transferring
any objects. But if i am using the Data transformation services 2k - transfer sql server task its working.

thanks

Scott Whigham

Posted: Tuesday, February 05, 2008 3:02:30 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hmmmm - do you have the errors or logs? Can you run Profiler to verify that it is running against the server?

dibyant

Posted: Tuesday, February 05, 2008 9:36:01 PM

Rank: Newbie

Joined: 1/21/2008
Posts: 9
Points: -73
Location: usa

there is no error also it show the successful but no data or table get transfered
it shows --progress transferring objects-0 percent complete with information like no
store procedure/data/default...( what i haven't selected thats why it shows this information)
even i have installed SP2 but it has no improvement.
but if i do the same task in dts it does, i don't know why its not working in BIDS.
ANY POSSIBLE REASON

Scott Whigham

Posted: Monday, February 11, 2008 2:45:10 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

No clue - sorry. I haven't heard of that happening and it's possibly a bug. Have you checked to see if it is on Microsoft Connect listed as a bug? http://connect.microsoft.com/

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.