Using sample files

[cfriedberg]

I have a book Microsoft SQL Server 2000 DTS for which I have downloaded exercises to use as samples; then files are CallTestDTS.SQL, TestDTS.dts, and Chapter1DTSDemo.dts.

My questions are "Where do I install the files, and How do I access them so that I can use them with SQL?"

 

[DrewConn]

You should have a folder on your server drive that holds your data. I think the default is MSSQL7\Data. You can import your packages into this folder.

You can also execute your packages from a command line using DTSRUN if you are not using EM. The syntax is:

dtsrun [/?|/[~]S server_name/[~] username/[~]password |/E|/[~]F filename/[~]R reposotory_database/[~]N package_name[/M[~]package_password]|[/[~]package_string]|[/[~]V package_version_string][/!X][/!D][/!Y][/!C]

For obvious reasons I always use EM but this is an option for those who are EM deprived.