Re: Attn. Darren Green - Truncation problem in DTS

#1

In article <7fc96a6c.0308201053.327fc2d1 (AT) posting (DOT) google.com>, Jane
<janemazur (AT) hotmail (DOT) com> writes

Quote:

I was searching Google Groups trying to find a solution to a text
string being truncated when using a DTS package, and came across your
reply to one of the posting. You referred to a SQLDTS website (which I
also use quite often!). I downloaded your custom BulkExportTask task,
but seems that the version available for download is not the one where
properties are available to the ActiveX.

What I am trying to do, is not only export records with the long text,
but also dynamically set the file name to reflect the date, as this
job should run automatically every day.
The other issue I am having, is that same job should update the
exportDate field for the records that were exported, but I guess for
this one I'll have to find a work around.

Could you please direct me to a latest version of BulkExportTask?

Thanks a lot!

Jane,
My apologies, I have clearly lost the plot on that one, and will
investigate it.

Here is some ActiveX Script that does work-

Option Explicit

Function Main()

Dim oPkg, oBulkExport

Set oPkg = DTSGlobalVariables.Parent
Set oBulkExport =
oPkg.Tasks("DTSTask_DTSBulkExport.ExportData_1").C ustomTask

oBulkExport.Properties("ExportFile").Value = "Fred"

Set oBulkExport = Nothing
Set oPkg = Nothing

Main = DTSTaskExecResult_Success
End Function

Please remember to set the ActiveX Script Task to execute on the main
thread (Right-click the task and select Workflow Properties), as the
custom task is written in VB.

Cheers
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

#2

Thanks Darren!
It worked!
Could you tell what are other available properties for this Task?

Thanks again for your help!

Jane

Darren Green <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote

Quote:

In article <7fc96a6c.0308201053.327fc2d1 (AT) posting (DOT) google.com>, Jane
janemazur (AT) hotmail (DOT) com> writes
I was searching Google Groups trying to find a solution to a text
string being truncated when using a DTS package, and came across your
reply to one of the posting. You referred to a SQLDTS website (which I
also use quite often!). I downloaded your custom BulkExportTask task,
but seems that the version available for download is not the one where
properties are available to the ActiveX.

What I am trying to do, is not only export records with the long text,
but also dynamically set the file name to reflect the date, as this
job should run automatically every day.
The other issue I am having, is that same job should update the
exportDate field for the records that were exported, but I guess for
this one I'll have to find a work around.

Could you please direct me to a latest version of BulkExportTask?

Thanks a lot!

Jane,
My apologies, I have clearly lost the plot on that one, and will
investigate it.

Here is some ActiveX Script that does work-

Option Explicit

Function Main()

Dim oPkg, oBulkExport

Set oPkg = DTSGlobalVariables.Parent
Set oBulkExport =
oPkg.Tasks("DTSTask_DTSBulkExport.ExportData_1").C ustomTask

oBulkExport.Properties("ExportFile").Value = "Fred"

Set oBulkExport = Nothing
Set oPkg = Nothing

Main = DTSTaskExecResult_Success
End Function

Please remember to set the ActiveX Script Task to execute on the main
thread (Right-click the task and select Workflow Properties), as the
custom task is written in VB.

Cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Attn. Darren Green - Truncation problem in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Attn. Darren Green - Truncation problem in DTS - 08-21-2003 , 03:05 PM

Re: Attn. Darren Green - Truncation problem in DTS - 08-28-2003 , 11:26 AM