May 14, 2005 at 3:28 pm
I did this
I have an DTS file to import into my server, for learning and testing.
I used these steps ...
To import the DTS Package itself into Sqlserver do the following in enteprise manager
1) right clcik on data transformation services
2) click open package
3) Select Package box...Find the file in the filesystem then press open.
It was on my C:\DTSExample\DTSfile.dts
4) Click open..
Then went to local packages in DTS and It was NOT there ???
I am a newbie, so what am I missing ??? Is it that it is a a FILE that it is not shown a reference in my "local package" display ??
May 15, 2005 at 7:14 am
The "Local Packages" folder list those packages that are saved in the local SQL Server (in the msdb database).
Package that are in file systems are never listed under any of the EM folders.
SQL = Scarcely Qualifies as a Language
May 15, 2005 at 1:01 pm
Thanks. had to be that simple
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply