DTS error [DNETLIB]

I am copying files from one database to another. Identical tables that I
created by just Generating SQL Scripts from the source database and running
it on my new database.
This works from most of my files.
One error I am getting for a few of tables is: [DNETLIB].
What is this?
Thanks,
Tom
Now I cannot even connect if I right click the database icon and choose
export data.
When I go to the first screen: Choose Data Source.
I get the following error:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB]
Context: Error during initialization of the provider.
How can that be?
I just ran this a couple of minutes ago and had no problem with it. I can
look at the tables fine in Sql Enterprise Manager.
Thanks,
Tom
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:O7QAaFW7GHA.2384@.TK2MSFTNGP04.phx.gbl...
>I am copying files from one database to another. Identical tables that I
>created by just Generating SQL Scripts from the source database and running
>it on my new database.
> This works from most of my files.
> One error I am getting for a few of tables is: [DNETLIB].
> What is this?
> Thanks,
> Tom
>

DTS error [DNETLIB]

I am copying files from one database to another. Identical tables that I
created by just Generating SQL Scripts from the source database and running
it on my new database.
This works from most of my files.
One error I am getting for a few of tables is: [DNETLIB].
What is this?
Thanks,
TomNow I cannot even connect if I right click the database icon and choose
export data.
When I go to the first screen: Choose Data Source.
I get the following error:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB]
Context: Error during initialization of the provider.
How can that be?
I just ran this a couple of minutes ago and had no problem with it. I can
look at the tables fine in Sql Enterprise Manager.
Thanks,
Tom
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:O7QAaFW7GHA.2384@.TK2MSFTNGP04.phx.gbl...
>I am copying files from one database to another. Identical tables that I
>created by just Generating SQL Scripts from the source database and running
>it on my new database.
> This works from most of my files.
> One error I am getting for a few of tables is: [DNETLIB].
> What is this?
> Thanks,
> Tom
>

DTS error [DNETLIB]

I am copying files from one database to another. Identical tables that I
created by just Generating SQL Scripts from the source database and running
it on my new database.
This works from most of my files.
One error I am getting for a few of tables is: [DNETLIB].
What is this?
Thanks,
TomNow I cannot even connect if I right click the database icon and choose
export data.
When I go to the first screen: Choose Data Source.
I get the following error:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB]
Context: Error during initialization of the provider.
How can that be?
I just ran this a couple of minutes ago and had no problem with it. I can
look at the tables fine in Sql Enterprise Manager.
Thanks,
Tom
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:O7QAaFW7GHA.2384@.TK2MSFTNGP04.phx.gbl...
>I am copying files from one database to another. Identical tables that I
>created by just Generating SQL Scripts from the source database and running
>it on my new database.
> This works from most of my files.
> One error I am getting for a few of tables is: [DNETLIB].
> What is this?
> Thanks,
> Tom
>

DTS - how to backup and restore the DTS script?

I recently started to use DTS to do some of my database maintenance works. May I ask how do I backup those DTS scripts and how do I import them back?

I can find the "Save As..." function and it allowed me to save the script to bas or dts file. But I cant seem to find any function for me to restore that saved file to the SQL Server.

Please help.I got this from a Microsoft support Webcast, "It really depends on where you're storing your DTS package. If the package is stored as a file, if you store it on MSDB, backing up to MSDB would take care of it." The second link is from Darren Green SQL Server MVP. Hope this helps.

http://support.microsoft.com/?scid=http://support.microsoft.com%2Fservicedesks%2Fwebcasts%2Fen%2Fwc120500%2Fwct120500.asp

http://www.sqldts.com/default.aspx?242

Kind regards,
Gift Peddie|||You can import a dts package by right clicking on data transformation services on left side of the screen. Then you click on the option 'Open package'. In the next screen you can select the package.|||

Hi,

That's OK that we can open the package and work on it and will save the package. BUT when we save the package it's not saving in the SQL server its saving in the same file,

So i want that How to get that file in my sql server so that i will not open and work on the file again and again. If i'll got this package in the sql server then i'll not need to open this DTS file again and agian. So how to do this.

the basic i want to ask abt DTS is.. HOW TO BACKUP DTS AND HOW TO RESTORE DTS.?