error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lot

Have you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug
|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint
|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lotHave you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

ERROR: A variable may only be added once to either the read lock list or the write lock list.

Hi,
I have set of 2 DTS packages, one of which calls the other by forming a command-line (dtexec) using a Execute Process task.

From the parent package-> Execute Process Task->
dtsexec /F etc... /<pkg variable> = "servername"

Each of the parent and the called package have a variable: "User::DWServerSQLInstance" which is mapped to the SQL server connection manager server name property using an expression. The outer package has the above variable and so does the inner called package (which gets assigned through the command line from the outerpackage call to inner)

I "sometimes" get the following error:

OnError,I4,TESTDOM\Administrator,ACDWAggregation,{A1F8E43F-15F1-4685-8C18-6866AB31E62B},{77B2F3C7-6756-46EB-8C01-D880598FB4B3},5/22/2006 5:10:28 PM,5/22/2006 5:10:28 PM,-1073659822,0x,The variable "User::DWServerSQLInstance" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Help would be appreciated!

I have seen other posts on this but, not able to relate the solution to my scenario.

Do you have multiple tasks (in the same package) executing in parallel, and using same variable, e.g. in property mappings?

If yes, I think this problem is fixed by this post-SP1 fixes collection:
http://support.microsoft.com/Default.aspx?id=918222

Alternatively, you may change the package so the tasks are executed sequentially by creating precedence constraints.|||

Hi Brian,
The child Package uses the User Variable: DWSQLInstanceName mentioned above to initialize 4 SQL Server connections (2 OLEDB & 2 ADO .NET) -- Only <<Server Name>> property using expressions.

I also checked that this error seems to be only on Multi-proc machine. Don't get the same on my laptop.

I cannot seralize the tasks since, the error is coming @. package level while evaluating the package expressions (i.e. for the connections) when the package starts.

What is the best way to still use expressions for connection server names but, get around this error?
Is this what is fixed in SP1?

Also, it seems that the packages does not fail when it encounters the error which I am getting. I have MaxErrorCount = 1 for Package. The package goes ahead.

|||I believe the issue with connections sharing the variable is fixed in the commulative hotfix package I've mentioned above. It should be installed on top of SP1: first, install SP1 then install all the component packages from the hotfix package in the order they are listed in the article.

http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC
and then
http://support.microsoft.com/Default.aspx?id=918222|||This was indeed a bug and the post SP1 hotfix "fixes" it.

However, you can still create the bug. It's harder but stil there...|||

Thanks Michael and Crispin for the help on this!

I think we will need to upgrade to SP1 and install the Hotfix bundle for SP1. I think this should fix the issue which I am facing i.e. use of same variable for setting connection "Server Name" - Property in the expressions.

Thanks,
Gaurav

Error: -2147467259 (80004005); Provider Error: 0 (0)

Hi,
I have a couple of DTS job that runs daily. However, for the past three days
a different job has failed every night with very similar looking error
messages that are listed below. When I re-run the job after it fails it runs
fine and completes successfully. Any information to resolve this will be
highly appreciated.
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
network error. Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL ServerI think there used to be an issue like this due to something related to
connection pooling, and IIRC the workaround was to disable connection
pooling. Not sure if this is the same issue tho.
Did you try doing a search on support.microsoft.com?
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>|||Have see dozens of these, and almost everytime it was hardware or
connectivity driver related...not SQL Server
Stress test the network with NetMon running. Sorry I can't help on the
Netmon side. The stress test can be as simple as copying a HUGE file from
point A to point B.
I've seen corrupt/mismatched drivers, bad router ports and even crimped
cables cause this.
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>

Error: -2147467259 (80004005); Provider Error: 0 (0)

Hi,
I have a couple of DTS job that runs daily. However, for the past three days
a different job has failed every night with very similar looking error
messages that are listed below. When I re-run the job after it fails it runs
fine and completes successfully. Any information to resolve this will be
highly appreciated.
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
network error. Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL Server
I think there used to be an issue like this due to something related to
connection pooling, and IIRC the workaround was to disable connection
pooling. Not sure if this is the same issue tho.
Did you try doing a search on support.microsoft.com?
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>
|||Have see dozens of these, and almost everytime it was hardware or
connectivity driver related...not SQL Server
Stress test the network with NetMon running. Sorry I can't help on the
Netmon side. The stress test can be as simple as copying a HUGE file from
point A to point B.
I've seen corrupt/mismatched drivers, bad router ports and even crimped
cables cause this.
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>

ERROR: "activex component can't create object: 'excel.application'"

When I run a DTS, I get the following error.
Error I get: "activex component can't create object:
'excel.application'"
I was told not to load excel into sql server. Well, in any case, there
should not be any need to load excel, it recognizes the excel component
in the DTS, that means, it should be recognizing excel.
Please assist.
Thx,
Swim.
'***************************************
*******************************
' Visual Basic Transformation Script
'***************************************
*********************************
Function Main()
' Initialise dimensions
Dim appExcel
Dim newBook
Dim oSheet
Dim oPackage
Dim oConn
'Set excel objects
Set appExcel = CreateObject("Excel.Application")
Set newBook = appExcel.Workbooks.Add
Set oSheet = newBook.Worksheets(1)
' Populate heading columns for mapping purposes and display in excel
oSheet.Range("A1").Value = "Col1"
oSheet.Range("B1").Value = "Col2"
oSheet.Range("C1").Value = "Col3"
oSheet.Range("D1").Value = "Col4"
'Dynamically specify the name of the new Excel file to be created and
exported to
DTSGlobalVariables("fileName").Value = "C:\Rpts\cc\a.xls"
'" & DTSGlobalVariables("gvID").value & ".xls"
With newBook
.SaveAs DTSGlobalVariables("fileName").Value
.save
End With
appExcel.quit
set oPackage = DTSGlobalVariables.parent
'connection 2 is to the Excel file
set oConn = oPackage.connections(2)
oConn.datasource = DTSGlobalVariables("fileName").Value
'Destroy objects
set oPackage = nothing
set oConn = nothing
Main = DTSTaskExecResult_Success 'End on success
End FunctionIs your DTS package just exporting to or import from Excel or is it
instantiating Excel from a VBScript task?
"Swim" <crombusch@.gmail.com> wrote in message
news:1134093275.263026.230460@.g44g2000cwa.googlegroups.com...
> When I run a DTS, I get the following error.
> Error I get: "activex component can't create object:
> 'excel.application'"
> I was told not to load excel into sql server. Well, in any case, there
> should not be any need to load excel, it recognizes the excel component
> in the DTS, that means, it should be recognizing excel.
> Please assist.
> Thx,
> Swim.
>
>
>
>
> '***************************************
*******************************
> ' Visual Basic Transformation Script
> '***************************************
*********************************
> Function Main()
> ' Initialise dimensions
> Dim appExcel
> Dim newBook
> Dim oSheet
> Dim oPackage
> Dim oConn
> 'Set excel objects
> Set appExcel = CreateObject("Excel.Application")
> Set newBook = appExcel.Workbooks.Add
> Set oSheet = newBook.Worksheets(1)
> ' Populate heading columns for mapping purposes and display in excel
> oSheet.Range("A1").Value = "Col1"
> oSheet.Range("B1").Value = "Col2"
> oSheet.Range("C1").Value = "Col3"
> oSheet.Range("D1").Value = "Col4"
>
> 'Dynamically specify the name of the new Excel file to be created and
> exported to
> DTSGlobalVariables("fileName").Value = "C:\Rpts\cc\a.xls"
> '" & DTSGlobalVariables("gvID").value & ".xls"
> With newBook
> .SaveAs DTSGlobalVariables("fileName").Value
> .save
> End With
> appExcel.quit
> set oPackage = DTSGlobalVariables.parent
> 'connection 2 is to the Excel file
> set oConn = oPackage.connections(2)
> oConn.datasource = DTSGlobalVariables("fileName").Value
> 'Destroy objects
> set oPackage = nothing
> set oConn = nothing
> Main = DTSTaskExecResult_Success 'End on success
> End Function
>

Error: ""The transaction has exceeded the allotted time"

I receive this error "The transaction has exceeded the allotted time" in a pop-up sometimes when I use DTS. This happens in an alleatory way, when I run a package, when I try to open a package or save it, and normally happens when the machine is very busy with another process. I'm running SQL Server 2000 with SP2, and Windows 2000 Advanced Server with SP2.

Thank you very much in advance,

XavierWas any one able to find an answer to this? I'm getting the exact same error. Thanks.

Originally posted by xfolch
I receive this error "The transaction has exceeded the allotted time" in a pop-up sometimes when I use DTS. This happens in an alleatory way, when I run a package, when I try to open a package or save it, and normally happens when the machine is very busy with another process. I'm running SQL Server 2000 with SP2, and Windows 2000 Advanced Server with SP2.

Thank you very much in advance,

Xavier|||I solve it saving the packages as Local Packages instead of Meta Data Services Package: it never happens again|||So what is the difference between the two: "Local Packages" and "Meta Data Services Packages".

Thanks.

Originally posted by xfolch
I solve it saving the packages as Local Packages instead of Meta Data Services Package: it never happens again|||It works the same, but it's store in a different format:

When you save a Data Transformation Services (DTS) package, you save all DTS connections, DTS tasks, DTS transformations, and workflow steps and preserve the graphical layout of these objects on the DTS Designer design sheet.

You can save a package to:

Microsoft SQL Server.
With this default save option, you can store a package as a SQL Server msdb table, allowing you to: store packages on any instances of SQL Server on your network; keep a convenient inventory of saved packages in SQL Server Enterprise Manager; and create, delete, and branch multiple package versions during the package development process.

SQL Server 2000 Meta Data Services.
With this save option, you can maintain historical information about the data manipulated by the package. However, Meta Data Services and the repository database must be installed and operational on your server. You can track the columns and tables that are used by the package as a source or destination. You also can use the data lineage feature to track which version of a package created a particular row. You can use these types of information for decision-support applications.

Error Working With DTS -- "Class Not Registered"

I have a DTS package (stored in a .dts file) that was created in SQL Server 2000 and I am trying to work with it in SQL 2005. When I try to import it into the Legacy > Data Transformation Services node in Management Studio, I get a window that reads "Class Not Registered (Microsoft Data Transformation Services (DTS) Package)". I get the same error if I try to just execute the package itself from a query window.

I have Legacy Support installed, and I also have Integration Services installed.

Any ideas? We have three installations of SQL 2005 and I am getting the same error on all of them.

Have you installed Microsoft SQL Server 2000 DTS Designer Components from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

The DTS designer does not get installed with SSIS.

Thanks.

Error with schedule a DTS package...

Hi experts...

I'm trying to schedule a DTS package (import some tables from Mysql database) but there is
an error and I don't know how to resolve it.

The error is always the same...
"The job failed. The Job was invoked by Schedule 24 (Import RT data). The last step to run was step 1 (Import RT data)."

I have tried changing the all the parameters in the job properties, but I always obtein the same message.

The DTS package works fine, I can execute and it works, the problem is the schedule...

Thanks in advanced...What account is the scheduled task running under? Normally if you run it yourself and it works, you are running the DTS package with YOUR permissions. However, if you run the DTS package under a schedule, it is using the standard SQL Server account (which is either Local System or another specified account). You need to change the account the schedule runs under to have enough permissions to run properly.|||Thanks for your reply...

I have one more question... How can i change the account of the schedule task?... I don't know how can I change it.

The strange thing is that I've done the same with another databases, only one thing is different, the source, the schedules that work fine are between SQL databases and this is from Mysql to sql database... but this is not the problem becouse as I said I can execute it and it works fine.

thanks again.|||If you schedule a job in SQL Server, then on the Job Properties dialog window, click the Steps tab. Highlight the step (here, executing the DTS package job) that you want, and click Edit or properties. In the Job Step properties dialog window, click the Advanced tab, and there is a Run as user dropdownlist. Try changing that to your credentials.|||Hi Again,

There is a problem with this solution... the step type is CmdExec and you can't see this option unless you choose SQL Script type... I don't understand what's happening, I have read the documentation about Package Scheduling and Security Issues but I don't know how to change who invoked the job...

thanks again...|||That's an operating-system command or executable program command step. I'm not familiar with that. Is there any way to change the security context in the DTS package designer?|||Hi again...

The step is an operating system command... but as I said this job is similar to other... the only I can see related to the security context is the owner, and it's the same in all jobs that I have done (and they work fine).

thanks for your interest.|||Aha, I found this from databasejournal.com (link

You can also schedule execution of DTS packages using SQL Server Agent jobs. This ability is granted by default to the public group, based on permissions to execute sp_add_job and sp_add_jobschedule stored procedures in the MSDB database (this applies to all SQL Server Agent jobs, not just the ones that invoke DTS packages). Typically, it is recommended to restrict access to them to a limited number of privileged logins. While jobs typically execute in the security contexts of their owner, in the case of DTS packages this might be different. The reason is the fact that a task that contains invocation of a DTS package accomplishes this by the running DTSRun command line utility, which involves, in turn, the use of CmdExec. If you limit permissions to launch CmdExec jobs to members of the SysAdmin fixed server role (which is the default behavior), jobs will still execute in the same security context as their owners. However, you can change this default in the SQL Server Agent Properties dialog box, accessible by selecting the Properties option from the SQL Server Agent node under the Management folder in the SQL Server Enterprise Manager console. In the Job System tab, you need to clear the checkbox next to the "Only users with SysAdmin privileges can execute CmdExec and ActiveScripting job steps" and provide a Proxy Account name and password. The proxy account provides the security context for execution of DTS packages, so ensure that it has access to all relevant data stores, file system paths or COM components, which might be used by ActiveX scripting tasks. Remember, however, that at the same time you allow users without SysAdmin privileges to run potentially dangerous ActiveScripting jobs.|||Thanks a lot, but I haven't resolved the problem, I have seen this choice, and I put an administration user, but It didn't work... I don't know...

Sorry about your lost time.|||An administrative user for the box, or an administrative user on the domain? Domain permissions could be the problem.

You could also try posting to the Microsoft newsgroups, specifically the sqlserver.dts one:

http://communities.microsoft.com/newsgroups/default.asp

Then look for sqlserver.dts in the left frame after it downloads (it takes a while).

Error while trying to open/create a DTS - urgent

Hi,
I have MSDE SP3 installed and the only thing that I have changed
recently is my Windows login Password.
In the Enterprise Manager the SQL server is registered using mixed
authentication.
When I try to open any DTS in Design mode, I get an error dialog with
the title 'DTS Design error' and saying that:
"Error occured during creation of a DTS package"
and then when I click on the OKAY button I get the 2nd error dialog
saying:
"The selected package cannot be opened. The DTS designer has been
closed."
I am getting the same message when I try to create a new package
Can someone PLEASE help me out here.
Thanks.
Re-register the DTS dlls.
You can find them listed here
Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Learner" <wantnospam@.email.com> wrote in message
news:MPG.1bc14741c6d2435e989747@.msnews.microsoft.c om...
> Hi,
> I have MSDE SP3 installed and the only thing that I have changed
> recently is my Windows login Password.
> In the Enterprise Manager the SQL server is registered using mixed
> authentication.
> When I try to open any DTS in Design mode, I get an error dialog with
> the title 'DTS Design error' and saying that:
> "Error occured during creation of a DTS package"
>
> and then when I click on the OKAY button I get the 2nd error dialog
> saying:
> "The selected package cannot be opened. The DTS designer has been
> closed."
>
> I am getting the same message when I try to create a new package
> Can someone PLEASE help me out here.
> --
> Thanks.
|||Many thanks Allan. Appreciate your help.
Regards.

> | Re-register the DTS dlls.
> |
> | You can find them listed here
> |
> | Redistributing DTS with your program
> | (http://www.sqldts.com/Default.aspx?225)
> |
> |

Error While Running Dts

Hi,
I am trying to run a DTS from SP. The SQL code that I am using is as follows.......

exec master..xp_cmdshell 'dtsrun /S 142.102.27.207 /U sa /P sa /N DTS_TEST1'

But Running this I am getting the the following errror......
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Error opening datafile: The system cannot find the path specified.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Help file: DTSFFile.hlp
Help context: 0

Error Detail Records:
Error: 3 (3); Provider Error: 3 (3)
Error string: Error opening datafile: The system cannot find the path specified.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider

Help file: DTSFFile.hlp
Help context: 0

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.

NULLGuys......... Help me in this regard..............|||Is the SQL Instance your connecting to (142.102.27.207) local (the same server where you're running DTSRun)?

Also it's running from the context of the windows-account that's running SQL Server. Is that account allowed to access the file?|||The SqlServer Computer has been given the full control to the file where the data is to be transferred in the application server through DTS.|||where as when I am running from the command prompt of the application server, its running successfully...............

dtsrun /S 142.102.27.207 /U sa /P sa /N DTS_TEST1

NOTE:
SQLSERVER: 142.102.27.207
APPLICATION SERVER: 142.102.27.154

I have a folder named "TEST" in the application server, where i have given the "full control" to 142.102.27.207 (DB Server). Folder Test is having an excel file which is the destination object for the DTS. DTS is transferring teh data from a table to this excel file.|||it is definitly security related. Does the account running the sql server agent and sql server service have full control on test?

Error while executing nested DTS Packages...

Hello
We ran into a peculiar problem. We copied all of our DTS packages
from one server to another server (both of which run SQL 2000 and are
on the same Service Pack 3/3a). When we execute an embedded DTS
package from within anothe DTS package, we get the following error:

Error Title: Server Busy
Error Description: This action cannot be completed because the othe
program is busy. Choose 'Switch To' to activate the busy program and
correct the problem.

Buttons Available: Swith To..., Retry
Buttons Disabled: Cancel

Does any one know about this error and what to do about it?

Thanks
Jagannathan Santhanam (Jags)"Jagannathan Santhanam" <jags_32@.yahoo.com> wrote in message
news:605df08e.0309081332.73615acb@.posting.google.c om...
> Hello
> We ran into a peculiar problem. We copied all of our DTS packages
> from one server to another server (both of which run SQL 2000 and are
> on the same Service Pack 3/3a). When we execute an embedded DTS
> package from within anothe DTS package, we get the following error:
> Error Title: Server Busy
> Error Description: This action cannot be completed because the othe
> program is busy. Choose 'Switch To' to activate the busy program and
> correct the problem.
> Buttons Available: Swith To..., Retry
> Buttons Disabled: Cancel
> Does any one know about this error and what to do about it?
> Thanks
> Jagannathan Santhanam (Jags)

I've no idea what causes the error, but a search on Google found a few
similar cases. They seem to be related to ActiveX DLL problems. That's not
much to go on, but it might be something to investigate:

http://groups.google.com/groups?hl=...ram&sa=N&tab=wg

Simon

Error While DTS Execution from ASP

I ahve created a DTS package & was able to execute it
from backend but while trying to execute DTS Package
created in local Packages in sql client gets error.
Error Number 2147287038T
Error Description :The system cannot find the file
specified.
package Name :FSPETLISASUpload_DevServer1
Code used
set objDTSPackage = Server.CreateObject("DTS.Package")
on error resume next
objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
,
DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
rver1"
Response.Write err.number & err.Description
Thanks in advance
As a test you may want to try the script (change the obvious variables),
contained at the following link:
http://support.microsoft.com/default...b;en-us;252987
Steve
"Aparna" <nandi_aparna@.yahoo.com> wrote in message
news:02d201c49aa1$d1cef530$a401280a@.phx.gbl...
> I ahve created a DTS package & was able to execute it
> from backend but while trying to execute DTS Package
> created in local Packages in sql client gets error.
>
> Error Number 2147287038T
> Error Description :The system cannot find the file
> specified.
> package Name :FSPETLISASUpload_DevServer1
> Code used
> set objDTSPackage = Server.CreateObject("DTS.Package")
> on error resume next
> objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
> ,
> DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
> rver1"
> Response.Write err.number & err.Description
>
> Thanks in advance
>

Error while doing DTS from INFORMIX to MSSQL

Dear All,

I'm using the DTS to transfer data from Informix 7.30 UC9 to MS SQL 2000 Enterprise. The tables I'm transferring contains data for BaaN ERP.

While transferring certain tables, I am successful. On some, I get an error that says "Data overflow". It was caused by "DBTYPE_DBTIMESTAMP".

Any idea why this happens?

Thanks!I have seen it caused many of times in my experience with data conversion. It is generally caused when a date is incorrect.

BOL confirms Infomix information:
The Informix ODBC driver is not supported for use with DTS.
The Merant Informix OLE DB provider is supported for DTS imports from Informix, but not DTS exports to Informix. This driver also cannot be used to import meta data.

The Intersolv Informix ODBC driver is supported, but with the following restrictions:
BLOBs cannot be exported to Informix.

When creating new tables on Informix, the DTS Import/Export Wizard will incorrectly map the SQL Server 2000 datetime columns to the Informix 'Datetime year to fraction' data type. Manually change this to the Informix Date type.

The DTS meta data import will not import Informix catalog or table information.|||Thanks for such a speedy reply!

I've heard about this "Merant OLE driver" but I can't seem to download it from anywhere. Any clues?

Thanks again!

Originally posted by Satya
I have seen it caused many of times in my experience with data conversion. It is generally caused when a date is incorrect.

BOL confirms Infomix information:
The Informix ODBC driver is not supported for use with DTS.
The Merant Informix OLE DB provider is supported for DTS imports from Informix, but not DTS exports to Informix. This driver also cannot be used to import meta data.

The Intersolv Informix ODBC driver is supported, but with the following restrictions:
BLOBs cannot be exported to Informix.

When creating new tables on Informix, the DTS Import/Export Wizard will incorrectly map the SQL Server 2000 datetime columns to the Informix 'Datetime year to fraction' data type. Manually change this to the Informix Date type.

The DTS meta data import will not import Informix catalog or table information.