DTS_E_PRIMEOUTPUTFAILED

I'm attempting to import a dbf file into a SQL server staging table. The following error is being reported:

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DBF File" (1) returned error code 0x80040E21. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

Data provider is Jet 4.0. Is this just a corrupt file? Or does this indicate something else? The package has run successfully on all previous occasions. Thanks in advance.

Please provide the surrounding errors as well.|||

This is the first error in the chain. The others seem to be a result of this error, but for completeness, I will include them here.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0x80040E21. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Thank you for your kind assistance.

|||You might want to read through this to see if anything works for you.

http://adopenstatic.com/faq/80040e21.asp|||Well, the file is definitely corrupt. I'm getting an error when I try to import it to Access.|||

Benda Fenda wrote:

Well, the file is definitely corrupt. I'm getting an error when I try to import it to Access.

Glad you got to that point at least.

DTS_E_COLUMNDATAOVERFLOWDISKIOBUFFER Error

Hi! I'm a newbie and I'm trying to create a SSIS package which would loop in a directory of comma delimited text files.

Could anybody help? I'm having a problem when I run my package.

[Flat File Source [524]] Error: The column data for column "IndicatorGroupID" overflowed the disk I/O buffer.
[Flat File Source [524]] Error: An error occurred while processing file "\\192.168.0.47\Temp\detail-2864EGGPUSH-20060315.txt" on data row 1.
[DTS.Pipeline] Error: The PrimeOutput method on component "Flat File Source" (524) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Please help...

:)

Try directing all erroring rows into into an error sink using the error output from your flat file source so you can examine them later. I imagine you have some erroneous data in there.

--Jamie

|||Thanks! I've already found the error. You were correct, I was not able to filter my loop. As it happened, it looped through all the files in the directory, even through the unparsed ones.I only needed it to loop through the parsed ones. Thanks again!

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Error

I have an SSIS Package that first goes out using an ActiveX script to search to see if an access database exists. If it exists it deletes it and recreates the database shell, if not it creates a new one. The second step is to create the tables the Access database is going to need. The last step is to populate the Access tables with data from a SQL Server database. I have changed the package from running in 64Bit to False. I have tried EVERY security mode for the package and the package still fails with the:

[Access - Definition [3781]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[DTS.Pipeline] Error: component "Access - Definition" (3781) failed the pre-execute phase and returned error code 0xC020801C.

Please help!

Thanks!

The error message may be appearing for one of the following reasons:

· The connection string specifies a provider that is not supported.

· You do not have access to the specified data source.

· The specified data source is being used by another application.

|||

Thanks for your help! What I had to end up doing is...I have 83 tables I need to copy over to Access...so come to find out I had to split half of the tables over to another data flow and now I see nothing but green when I execute the package...its the weirdest thing...but it works so I am going with it...thanks for you help tho!

|||I know that this question is update dbut for others who have the same problem need to check out the security option. If you're using a password to access a dB then you have to use Persist Security info=true otherwise use Integrated security=true

Good luck

Dts?

I need to do the following for a client.
1. Download by FTP a zipped file that contains 10 text files
2. Unzip the file to get to the text files
3. Import data from the text files into separate tables in SQL Server.

notes:
Text files are pipe-delimited.
This is a hosted sql server...therefore I don't have full admin rights or access to other folders on the sql box.

Can this be done using a dts? I've never used DTS, but it seems like this is possible just messing around with the DTS

designer.

Can the unzip part be scripted using a activeX/com component?

Could I use my local server to download the file, then use my local enterprise manager and create the dts to import the data into their remote db?

Thanks for any help!!!! :eek:Yes this can be done. You'll probably have to download the FTP task from www.sqldts.com (http://www.sqldts.com). I'm not sure if the zip process can be done via activeX but it can definately be done using xp_cmdshell. As far as your local server, it can be done that way but sounds risky to me for a production process. Why not deploy the DTS package to the host SQL Server and ftp the files to a network location then import the data into the tables?|||Why not just write a sproc?

And as far as it's hosted...are you saying you can't write to a local drive?

DTS: Visual FoxPro to SQL Server

Hi,

Today was my first day to use DTS. I tried to transfer a Visual FoxPro Database to my SQL Server. I noticed that I am getting errors on the data that contains date fields. So, for testing purposes I transformed the Visual FoxPro fields that contained datefields into char fields. And this works, but obviously I cannot hunt around in a huge database looking for datefields in tables and change them manually. Plus, by changing to char fields I noticed that those fields that are empty are transformed as 1899-12-30. :p

Does anyone have any ideas?

Thanks,
LauraWhat's the source field datatype?|||The field types are smalldate.|||To make it as paifull as possible, I'd DTS the FP table into a staging table and go from there.

DTS: Transform Data Task with ActiveX

I trying to write out comment records in 40 byte chunks from a much longer
field(see below) but I can't find any way of writing out the records inside
the loop. The code below works (and the loop is being executed) but nothing
turns up in the output. Does anyone have any thoughts?
'***************************************
********************
' Visual Basic Transformation Script
'***************************************
********************
' Copy each source column to the destination column
dim Comment
dim CommentOut
dim CommentSub
Function Main()
if DTSSource("OrderID") <> DTSGlobalVariables("OrderID") then
' Process Comments
Comment = DTSGlobalVariables("Comment")
Do While len(Comment) > 0
if len(Comment) > 40 then
CommentOut = left(Comment,40)
CommentSub = mid(Comment,41,len(Comment)-40)
Comment = CommentSub
else
CommentOut = Comment
comment = ""
end if
DTSDestination("OrderID") = DTSGlobalVariables("OrderID")
DTSDestination("LineNumber") = DTSGlobalVariables("LineNumber")
DTSDestination("Comment") = CommentOut
Main = DTSTransformStat_OK
Loop
' Store Comment from the record causing the control break
DTSGlobalVariables("OrderID") = DTSSource("OrderID")
DTSGlobalVariables("Comment") = DTSSource("PackingNote")
end if
Main = DTSTransformStat_OK
End FunctionProblem sorted. Please ignore...
"Spike" wrote:

> I trying to write out comment records in 40 byte chunks from a much longer
> field(see below) but I can't find any way of writing out the records insid
e
> the loop. The code below works (and the loop is being executed) but nothi
ng
> turns up in the output. Does anyone have any thoughts?
> '***************************************
********************
> ' Visual Basic Transformation Script
> '***************************************
********************
> ' Copy each source column to the destination column
> dim Comment
> dim CommentOut
> dim CommentSub
>
> Function Main()
> if DTSSource("OrderID") <> DTSGlobalVariables("OrderID") then
> ' Process Comments
> Comment = DTSGlobalVariables("Comment")
> Do While len(Comment) > 0
> if len(Comment) > 40 then
> CommentOut = left(Comment,40)
> CommentSub = mid(Comment,41,len(Comment)-40)
> Comment = CommentSub
> else
> CommentOut = Comment
> comment = ""
> end if
> DTSDestination("OrderID") = DTSGlobalVariables("OrderID")
> DTSDestination("LineNumber") = DTSGlobalVariables("LineNumber")
> DTSDestination("Comment") = CommentOut
> Main = DTSTransformStat_OK
> Loop
> ' Store Comment from the record causing the control break
> DTSGlobalVariables("OrderID") = DTSSource("OrderID")
> DTSGlobalVariables("Comment") = DTSSource("PackingNote")
> end if
> Main = DTSTransformStat_OK
>
> End Function
>
>

DTS: Strange error when calling a sub-package.

(SQL Server 2000, SP3a)
Hello all!
I've been wrestling with a bear of a problem with my DTS Package. It has a sub-package
(several of them, actually), and when I run the package in the DTS "designer" (from
Enterprise Manager) or DTSRUN.exe, everything works splendidly!
I have since made a VBScript "driver" program that is using the COM interface to DTS, and
when I execute the package, it fails with the following error:
Execution was canceled by user.
This error occurs just before calling the sub-package (which is invoked with the "Execute
Package Task"), but the previous two tasks (Dynamic Properties and ActiveX Tasks) are
successful before that Execute Package Task fails with the above error.
I've been pulling my hair out all day trying to figure out what's causing this.
If anyone can help shed some light on this issue, I'd be *hugely* obliged! Thanks in
advance!
John PetersonSet all your tasks to execute on the main thread.
Are you using Events ?
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eJTre0QTEHA.2716@.tk2msftngp13.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> I've been wrestling with a bear of a problem with my DTS Package. It has
a sub-package
> (several of them, actually), and when I run the package in the DTS
"designer" (from
> Enterprise Manager) or DTSRUN.exe, everything works splendidly!
> I have since made a VBScript "driver" program that is using the COM
interface to DTS, and
> when I execute the package, it fails with the following error:
> Execution was canceled by user.
> This error occurs just before calling the sub-package (which is invoked
with the "Execute
> Package Task"), but the previous two tasks (Dynamic Properties and ActiveX
Tasks) are
> successful before that Execute Package Task fails with the above error.
> I've been pulling my hair out all day trying to figure out what's causing
this.
> If anyone can help shed some light on this issue, I'd be *hugely* obliged!
Thanks in
> advance!
> John Peterson
>|||Hey Allan!
Yeah...all my tasks were executing on the Main thread. I'm not sure what you mean by
"using Events"?
I did stumble across this issue:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;319058
But I don't know how to handle events in VBScript. My guess is that I can't. :-(
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OrnlCDTTEHA.3944@.TK2MSFTNGP12.phx.gbl...
> Set all your tasks to execute on the main thread.
> Are you using Events ?
> --
> --
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:eJTre0QTEHA.2716@.tk2msftngp13.phx.gbl...
> > (SQL Server 2000, SP3a)
> >
> > Hello all!
> >
> > I've been wrestling with a bear of a problem with my DTS Package. It has
> a sub-package
> > (several of them, actually), and when I run the package in the DTS
> "designer" (from
> > Enterprise Manager) or DTSRUN.exe, everything works splendidly!
> >
> > I have since made a VBScript "driver" program that is using the COM
> interface to DTS, and
> > when I execute the package, it fails with the following error:
> >
> > Execution was canceled by user.
> >
> > This error occurs just before calling the sub-package (which is invoked
> with the "Execute
> > Package Task"), but the previous two tasks (Dynamic Properties and ActiveX
> Tasks) are
> > successful before that Execute Package Task fails with the above error.
> >
> > I've been pulling my hair out all day trying to figure out what's causing
> this.
> >
> > If anyone can help shed some light on this issue, I'd be *hugely* obliged!
> Thanks in
> > advance!
> >
> > John Peterson
> >
> >
>|||Well...I got to the heart of my problem, and it can be best explained by this MS KB
article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;319058
I had someone help me write a quick-n-dirty .NET C# wrapper for the DTS package, and when
we put in the event handler for OnQueryCancel, sure enough, this bug reared its ugly head.
:-(
It's unfortunate, because I had some measure of work invested in my VBScript application,
but because I can't write an event handler in VBScript, I cannot rectify this situation in
that environment.
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eE%23GgsVTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hey Allan!
> Yeah...all my tasks were executing on the Main thread. I'm not sure what you mean by
> "using Events"?
> I did stumble across this issue:
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;319058
>
> But I don't know how to handle events in VBScript. My guess is that I can't. :-(
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OrnlCDTTEHA.3944@.TK2MSFTNGP12.phx.gbl...
> > Set all your tasks to execute on the main thread.
> >
> > Are you using Events ?
> >
> > --
> >
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > "John Peterson" <j0hnp@.comcast.net> wrote in message
> > news:eJTre0QTEHA.2716@.tk2msftngp13.phx.gbl...
> > > (SQL Server 2000, SP3a)
> > >
> > > Hello all!
> > >
> > > I've been wrestling with a bear of a problem with my DTS Package. It has
> > a sub-package
> > > (several of them, actually), and when I run the package in the DTS
> > "designer" (from
> > > Enterprise Manager) or DTSRUN.exe, everything works splendidly!
> > >
> > > I have since made a VBScript "driver" program that is using the COM
> > interface to DTS, and
> > > when I execute the package, it fails with the following error:
> > >
> > > Execution was canceled by user.
> > >
> > > This error occurs just before calling the sub-package (which is invoked
> > with the "Execute
> > > Package Task"), but the previous two tasks (Dynamic Properties and ActiveX
> > Tasks) are
> > > successful before that Execute Package Task fails with the above error.
> > >
> > > I've been pulling my hair out all day trying to figure out what's causing
> > this.
> > >
> > > If anyone can help shed some light on this issue, I'd be *hugely* obliged!
> > Thanks in
> > > advance!
> > >
> > > John Peterson
> > >
> > >
> >
> >
>