Nope...

What is the problem?

In DTS is better to use UNC path, specialty if you want to schedule as job later.

Make sure you have permission on the network.

JFB

Hi,

You can check a record if exist in some table using lookups in DTS.

Here is an example in how to use it...

http://www.sqldts.com/default.aspx?6,107,277,7,1

JFB

Hi,

99% of the scheduling problems it fixed with this article..

DTS schedule problem

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

JFB

Hi,

Yes it's a problem with memo fields.

You can change the field to nvarchar or transform to nvarchar when you get the filed into SQL.

JFB

Hi,

You can use DTS package to perform this task.

Here is an example.

http://www.sqldts.com/default.aspx?6,107,276,7,1

JFB

Hi fuddin,

After you get all the files perform a loop to import to SQL like this example

http://www.swynk.com/friends/green/dtsdirloopstep.asp

And use lookups for check duplicate rows.

Regards

JFB

Hi,

Yes you can execute structured storage file with DTSRUN utility.

dtsrun /Ffilename /Npackage_name /Mpackage_password

Regards

Johnny

Hi,

Did you read this article

DTS schedule problem

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

Maybe help to find the problem

Regards

JFB

Hi,

You need to use DTSRUN utility, check BOL for more information.

This can be called from within T-SQL using the xp_cmdshell extended stored procedure.

Regards.

JFB

Hi jwt

Here is how and a great backup tool

http://www.sqldts.com/default.aspx?6,105,204,0,0

JFB

Hi Daniel,

Yes you can...!

DTSGlobalVariables("File").Value=DTSGlobalVariables("path").Value & DTSGlobalVariables("fileName").Value

JFB

Hi,

Try to re-register the axscphst.dll file on you server.

Regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll

JFB

Hi,

Here is some information about you question

http://support.microsoft.com/?kbid=247052

JFB

Hi,

Also check here

DTS schedule problem

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

JFB

Make sure the account is using SQL agent have permission on the network.

JFB