May 16, 2005 at 3:46 am
Hi there,
hope someone can shed some light on the following:
I am in the process of moving DTS packages from one server to another. I first save the packages as structured files - I saved them to my desktop. Then I opened them on the destination server and saved them to sql server ......
The description of the DTS Packages on the Destination and Source Servers read "Please wait while exported nett pay data is imported into Connect". The Description has not changed since Friday.
What is wrong ? Is there anything wrong ?
Thanks in advance
May 16, 2005 at 7:28 am
I didn't see that problem before. Try to use this great tool to transfer you pkg and check if you have the same error.
http://www.sqldts.com/default.aspx?242
Rgds
Johnny
May 16, 2005 at 7:33 am
Thanks so much - will try
May 17, 2005 at 1:01 pm
that tool works well...
other resources/alternates:
http://www.sqldts.com/default.aspx?204
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=155452
sorry if you've already checked them out.
May 17, 2005 at 11:08 pm
you can use sqldmo to do this really easily. something similar to
with createobject("dts.package")
.loadfromsqlserver server,package
.savetoserver server, package
end with
the syntax on that isn't correct, but you can get the details from msdn online and it's pretty much that simple.
May 18, 2005 at 1:45 am
thank you all so much - I will probably have to go with the sqldmo - as the server environment I work on is pretty much 'locked down' meaning that any kind of software not approved by the powers that be is a no go ...
I am checking the tools out though and they seem pretty cool - being new to the SQL environment I wasn't aware that there are a host of third party tools that can be used with SQLServer
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply