DTS error - Cannot import a table

I have schedule DTS to import every day few tables. It had been working
great and had no problem. All of a sudden I started getting this error.
ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
TASK. 1 UNIDENTIFIED ERROR.
Thanks.any constraint violations caused by the new row? pk, unique, rule, default
etc?
"Mac" <mac@.hotmail.com> wrote in message news:Tz%oe.7720$nr3.842@.trnddc02...
>I have schedule DTS to import every day few tables. It had been working
> great and had no problem. All of a sudden I started getting this error.
> ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
> TASK. 1 UNIDENTIFIED ERROR.
> Thanks.
>
>|||Also, turn on exception reporting for the Data Pump (Transformation Task).
This will output the source row and any other error messages.
Also, turn on package logging. You can usually get more detailed
information from these logs that what is genereated in the Job Agent.
Sincerely,
Anthony Thomas
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:elb$rqsaFHA.3032@.TK2MSFTNGP10.phx.gbl...
any constraint violations caused by the new row? pk, unique, rule, default
etc?
"Mac" <mac@.hotmail.com> wrote in message news:Tz%oe.7720$nr3.842@.trnddc02...
>I have schedule DTS to import every day few tables. It had been working
> great and had no problem. All of a sudden I started getting this error.
> ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
> TASK. 1 UNIDENTIFIED ERROR.
> Thanks.
>
>sql

DTS and Excel

Do you need to have excel installed to export files to excel using dts?

I don't think it does but I don't ever remember working on a computer without excel installed... can someone confirm? thank you very much in advance for your help.

No, DTS will create an xls formated file (csv) that can then be opened and used by Excel.

But Excel does NOT have to be on the server.

DTS and "SQL Server does not exist or access denied"

I recently had a problem with a process that had been working, well, forever
.
The process starts a DTS package step (SQL Server 2000, Windows Server 2003
on both machines; both machines are in the same domain, behind our firewall)
that copies records from one server to another. For some reason, it returned
the "SQL Server does not exist or access denied" error. The problem started
abruptly on Dec 8, 2005.
I noticed after a while that the the process always died after the same
number of records, 3950 +- 3. On a whim, just for kicks, I went into debug
and ran the VB6 program that creates the DTS package and set the
InsertCommitSize to 100 (it had been zero), and this cleared up the error.
My questions are:
1) Has anyone else run into this?
2) It looks like something out there didn't like the size of the buffer I
sent to it. Does anyone know why?
3) Does the size of the BLOB have anything to do with this?
I'd appreciate any response I can get from anyone else who has run into
this, and what they may have done to fix it when they got it.hi Mike,
How odd! I've got about 600 dts running on day-to-day basis and neither of
them own that property to 100, always own zero. I experienced problems with
'Copy objects' task when source database own field with data type as 'text',
for example.
--
current location: alicante (es)
"MikeM in Sac" wrote:

> I recently had a problem with a process that had been working, well, forev
er.
> The process starts a DTS package step (SQL Server 2000, Windows Server 200
3
> on both machines; both machines are in the same domain, behind our firewal
l)
> that copies records from one server to another. For some reason, it return
ed
> the "SQL Server does not exist or access denied" error. The problem starte
d
> abruptly on Dec 8, 2005.
> I noticed after a while that the the process always died after the same
> number of records, 3950 +- 3. On a whim, just for kicks, I went into debug
> and ran the VB6 program that creates the DTS package and set the
> InsertCommitSize to 100 (it had been zero), and this cleared up the error.
> My questions are:
> 1) Has anyone else run into this?
> 2) It looks like something out there didn't like the size of the buffer I
> sent to it. Does anyone know why?
> 3) Does the size of the BLOB have anything to do with this?
> I'd appreciate any response I can get from anyone else who has run into
> this, and what they may have done to fix it when they got it.

DTS 2000 not running in SQL Server 2005

I'm having a problem running a legacy DTS in SQL 2005. I've installed the
Feb 2007 feature pack and my DTS jobs still are not working. I open package
and click start, the package runs for a few moments and then abruptly closes
Management Studio. I've tried running this from SQL Agent and it still
failes.
The package was created with the BI accelerator.
Thanks,
--
RonHi Ron
Have you run SQL profiler against it to see what is happening? If this uses
a third party component has his been installed correcly?
John
"Ron" wrote:
> I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> Feb 2007 feature pack and my DTS jobs still are not working. I open package
> and click start, the package runs for a few moments and then abruptly closes
> Management Studio. I've tried running this from SQL Agent and it still
> failes.
> The package was created with the BI accelerator.
> Thanks,
> --
> Ron|||John,
Thanks for the reply. Actually the BI Accelerator is/was a Microsoft
Application (Microsoft Accelerator for BI), but I believe it's been retired.
I think the issue was with the compatibility level of my DB's. I had them
set to 80 instead of 90. I'm going to do a bit more testing, but I hope that
was the problem.
If you can think of anything else I should check please let me know.
Thanks,
--
Ron
"John Bell" wrote:
> Hi Ron
> Have you run SQL profiler against it to see what is happening? If this uses
> a third party component has his been installed correcly?
> John
> "Ron" wrote:
> > I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> > Feb 2007 feature pack and my DTS jobs still are not working. I open package
> > and click start, the package runs for a few moments and then abruptly closes
> > Management Studio. I've tried running this from SQL Agent and it still
> > failes.
> >
> > The package was created with the BI accelerator.
> >
> > Thanks,
> > --
> > Ron

DTS + .net code

Hi,
My web application take data from excel sheet and store in the
database using dts. it is working fine when i run directly dts package
on sql server 2000 but i call sp ( exec master..xp_cmdshell 'dtsrun /S
/N /E ' ) from dot net code then it gives error
"A severe error occurred on the current command. The results, if any,
should be discarded "
*** Sent via Developersdex http://www.codecomments.com ***Have you tried running the command using Query Analyzer? If that works, try
adding 'no_output' to the statement executed by the application:
exec master..xp_cmdshell 'dtsrun /S /N MyPackage /E', no_output
Hope this helps.
Dan Guzman
SQL Server MVP
"Pooja Sharma" <pooja.sharma@.siliconbiztech.com> wrote in message
news:%23zgue0RSHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Hi,
> My web application take data from excel sheet and store in the
> database using dts. it is working fine when i run directly dts package
> on sql server 2000 but i call sp ( exec master..xp_cmdshell 'dtsrun /S
> /N /E ' ) from dot net code then it gives error
> "A severe error occurred on the current command. The results, if any,
> should be discarded "
>
> *** Sent via Developersdex http://www.codecomments.com ***

DTS - ActiveXScripting Not Working on 64bit AMD Cluster on SQL Server 2005 SP2

I have a problem with DTS - ActiveXScripting that it cannot initialize the script engine, I have the backward compatibility stuff installed, even tried a repair but still does not work.

Many thanks for any help you can provide on this problem.

Paul

Error Information below:

Date 17/04/2007 13:07:32
Log Job History (Test ActiveX Script)

Step ID 1
Server GBCONV1A002V03
Job Name Test ActiveX Script
Step Name Step 1: Exec TestActiveX script
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: WW004\ConSrvSQLAgentA002. ...TSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220487 (800403F9); Provider Error: 0 (0) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_1' failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: ... Process Exit Code 1. The step failed.

Try asking in the DTS usenet group.

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

DTExec is not working in xp_cmdShell

Hi All,

When I was trying to execute an SSIS package from DTExec using xp_cmdShell, it is giving an error message saying "unrecognized command,...". This error I am getting only in my Staging Environment. But at the same time, it is working fine with Development and Production servers.

I suspect the issue should be with config or access issues. So if anyone of you faced the same problem or if anyone have any solution, please share with me.

Thanks in advance for your help.

Thanks & Regards,

Prakash Srinivasan

Two things:
- Make sure you are using the full path to dtexec.exe.
- Is SSIS actually installed on the staging server?

DTC Problems on SQL 2000/Windows Server 2003

I have an ASP application that is working on IIS 4.0/NT 4.0 and SQL Server 7.0/NT 4.0. The ASP pages are using a package registered in the MTS 2.0 running on the IIS server.

I am starting to move my databases over to a new server running SQL Server 2000 on Windows Server 2003.

When I change the database server name in the connection string on the ASP pages and then attempt to run that page I get:

Microsoft OLE DB Provider for SQL Server error '8004d00a'

New transaction cannot enlist in the specified transaction coordinator.

I have confirmed that the Distributed Transaction Controller is running on my new SQL Server box and I have confirmed that network DTC access is on. If I stop the DTC service on my new SQL Server, the error message indicates that the DTC is not running.

Now I am stuck. Any ideas would be greatly appreciated.

Jeff BanningPlease check out Q329332 for help.

Sarah

DTA Compatibility

Phil move this post to SQL 2005 forum.

I suppose my lack of English was the reason, so I post it again.

I'm working with DTA Katmai SQL Server 2008.

Runing the next query using DTA:

selectLTrim(RTrim(CodCtaCte))as CodCtaCte, Nombre from CtaCtes where CuePrefi ='C'orderby Nombre

with SQL Server 2000 SP4 instance, I got this error:

"Tuning process exit unexpectedly"

Now, the same DTA and query but using SQL Server 2005 SP2 instances, works fine.

Both insances are in the same Server with Windows 2003.

Any clue?

Luis

I guess there was bug within SQL 2005 too working with DTA as that was found to be a bug in DTA in dealing with indexed views, in your case I woudln't take a guess that you are using Indexed views or any of them are involved or not.

|||Satya (old friend),

I never had a problem with DTA 2005 and SQL 2000.
If fact, DTA 2005 provide better indexes than ITW.
May be is a Katmai bug.|||So, I have to understand Katmai will not support sql 2000. I'm right?|||

From your posting it seems that DTA Katmai against Shiloh fails while DTA Katmai against Yukon works.Is this correct?

Potentially this is hitting a bug when DTA tries to analyze the showplan_parsing output for a query . This is not a problem in SQL Server 2005 since we use the more robust showplan_xml interface.

Can you check if there are any dtaengine mini dumps in the ErrorDumps Folder ? (typically the path is C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps) .If so we can take a look at the minidumps

Please let me know

Manoj

|||Your first question is correct.

Also there is no problem with DTA 2008 and SQL 2005.

There is nothing in ErrorDumps.

Thanks.|||

Hi Luis

Given that there are no user mode dumps the best way to proceed would be to file the problem as a bug using the connect program. It will be easier to debug if you have a representative database and workload.

Let us know if you have any questions on how to proceed

Manoj

DTA Compatibility

Phil move this post to SQL 2005 forum.

I suppose my lack of English was the reason, so I post it again.

I'm working with DTA Katmai SQL Server 2008.

Runing the next query using DTA:

select LTrim(RTrim(CodCtaCte)) as CodCtaCte, Nombre from CtaCtes where CuePrefi = 'C' order by Nombre

with SQL Server 2000 SP4 instance, I got this error:

"Tuning process exit unexpectedly"

Now, the same DTA and query but using SQL Server 2005 SP2 instances, works fine.

Both insances are in the same Server with Windows 2003.

Any clue?

Luis

I guess there was bug within SQL 2005 too working with DTA as that was found to be a bug in DTA in dealing with indexed views, in your case I woudln't take a guess that you are using Indexed views or any of them are involved or not.

|||Satya (old friend),

I never had a problem with DTA 2005 and SQL 2000.
If fact, DTA 2005 provide better indexes than ITW.
May be is a Katmai bug.|||So, I have to understand Katmai will not support sql 2000. I'm right?|||

From your posting it seems that DTA Katmai against Shiloh fails while DTA Katmai against Yukon works.Is this correct?

Potentially this is hitting a bug when DTA tries to analyze the showplan_parsing output for a query . This is not a problem in SQL Server 2005 since we use the more robust showplan_xml interface.

Can you check if there are any dtaengine mini dumps in the ErrorDumps Folder ? (typically the path is C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps) .If so we can take a look at the minidumps

Please let me know

Manoj

|||Your first question is correct.

Also there is no problem with DTA 2008 and SQL 2005.

There is nothing in ErrorDumps.

Thanks.|||

Hi Luis

Given that there are no user mode dumps the best way to proceed would be to file the problem as a bug using the connect program. It will be easier to debug if you have a representative database and workload.

Let us know if you have any questions on how to proceed

Manoj

DTA Compatibility

Phil move this post to SQL 2005 forum.

I suppose my lack of English was the reason, so I post it again.

I'm working with DTA Katmai SQL Server 2008.

Runing the next query using DTA:

select LTrim(RTrim(CodCtaCte)) as CodCtaCte, Nombre from CtaCtes where CuePrefi = 'C' order by Nombre

with SQL Server 2000 SP4 instance, I got this error:

"Tuning process exit unexpectedly"

Now, the same DTA and query but using SQL Server 2005 SP2 instances, works fine.

Both insances are in the same Server with Windows 2003.

Any clue?

Luis

I guess there was bug within SQL 2005 too working with DTA as that was found to be a bug in DTA in dealing with indexed views, in your case I woudln't take a guess that you are using Indexed views or any of them are involved or not.

|||Satya (old friend),

I never had a problem with DTA 2005 and SQL 2000.
If fact, DTA 2005 provide better indexes than ITW.
May be is a Katmai bug.|||So, I have to understand Katmai will not support sql 2000. I'm right?|||

From your posting it seems that DTA Katmai against Shiloh fails while DTA Katmai against Yukon works.Is this correct?

Potentially this is hitting a bug when DTA tries to analyze the showplan_parsing output for a query . This is not a problem in SQL Server 2005 since we use the more robust showplan_xml interface.

Can you check if there are any dtaengine mini dumps in the ErrorDumps Folder ? (typically the path is C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps) .If so we can take a look at the minidumps

Please let me know

Manoj

|||Your first question is correct.

Also there is no problem with DTA 2008 and SQL 2005.

There is nothing in ErrorDumps.

Thanks.|||

Hi Luis

Given that there are no user mode dumps the best way to proceed would be to file the problem as a bug using the connect program. It will be easier to debug if you have a representative database and workload.

Let us know if you have any questions on how to proceed

Manoj

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DSO on AS2005

Right now I am just working with DSO 8.5 and AS2005 in VB .NET (framework 2.0). I am trying to create an MDX statement called [Year to Date Amount] but when I do that, something puts brackets around Date to make it [Year to [Date] Amount] which will cause an MDX script error when processing it.

Someone mentioned this was a known issue and is going to be in SP2 but I was wondering if anyone knows where/if there is a hotfix for this?

Yes, I will be switching to AMO asap but I wanted to make sure what I have works with AS2005 right now (or will work with a simple patch).

Thank you.

This very much could be a known problem.

But please go ahead and file it using feedback site: http://connect.microsoft.com/SQLServer/feedback/.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.