Hi cross,

Check here.... DTS schedule problem

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

HI,

Are you using mapped drive?

You should use UNC path (\\servername\folder\filename.txt)

JFB

Do you have cubes somewhere?

Check Execute pkg on main thread...this option is in workflow properties.

Also check permissions.

JFB

Also check permissions on the network.

JFB

Hi,

Not really... in DTS you can use one source multiple times in column destinations.

With BCP task you can skip first row and determine how many rows you need to import.

With...

Hi,

Check option Execute on Main Pkg Thread on the workflow porperties.

JFB

Hi use lookups...

example

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

JFB

Hi,

Use lookups to check if the record exist skip if not import into the table.

Don't need temp tables.

Example

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

JFB

quote:

---

buijules:

How do you change the file in a tilde delimite file? Excel does not have the option to save files into this...

Hi,

Or you can use lookups to perform this...

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

JFB

Hi,

looks like permission error

Or

are you using text columns data type somewhere?

JFB

Hi,

Personally I don't like to use outlook inside SQL.

Incorporate the tool in the link and you wont have any more problems.

http://sqldev.net/xp/xpsmtp.htm

JFB

Hi,

Did you install sp2 in both pc's?

If not... install I thing this will fix you problem.

JFB

Hi,

You actually has problem with the versions.

http://www.sqldts.com/default.aspx?6,222,223,0,1

JFB

Hi Ken,

To make this work... everytime you fire DTS pkg you need to create a dinamic new flat file with different name and at the end of the pkg you...