September 9, 2004 at 7:32 am
I was given a .DTS file to import a database.
I've never ran it as a file. How do I do that?
How this thing works in general?
I mean when I run DTS from SQL Server DTS package
has all the server connections, all the servers are registered
in EM. But when you run an unknown .DTS file what if one of the
connections is missing? It will probably fail. Am I right?
Thanks
September 10, 2004 at 12:33 am
Hi Riga1966,
you can run a DTS from the command line using DTSRun. Look up the exact details in B.O.L.
As an example, I run one with the following command:
DTSRun /S 127.0.0.1 /E /L LogFile.txt /N "ImportDatabase"
to import the DTS file "ImportDatabase.Dts", and to log the output to a text file.
Hope this points you in the right direction
September 10, 2004 at 4:07 am
Hi,
To import the DTS Package itself into Sqlserver do the folloiwing in enteprise manager
1) right clcik on data transformation services
2) click open package
3) Find your file in the filesystem then press open.
You should then be able to see your package in enteprise manager.
Pete
September 10, 2004 at 6:51 am
Thank you guys for a quick response.
It was helpful.
But what if that .DTS file has connections
that don't exist on my computer.
Then obviously DTS package will fail?
September 16, 2004 at 12:03 pm
Yes the package will fail if the database names within the package don't exist. You will have to open the pakage in DTS Designer and repoint the database connections to the appropiate database. This has to be done manuelly and it can only be done in the Designer. There is no wizard to change existing database connections in a package. If you are only familiar with using the DTS wizard then either you're going to have to learn how to use the Designer or accept the fact that you're screwed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply