What is the problem?

JFB

Hi,

You can use multiple workflow as this example

http://www.sqldts.com/default.aspx?6,103,218,7,0

JFB

Hi,

One solution: Create a .csv file from excel before import this file to sql clean all the extra commas using regular expressions and then import the file.

Example for regular expressions

Is all data in one sheet?

Maybe you have extra comma in the file is causing the problem

Johnny...

scotttr,

You need to delete the file before create it again OR the file is open when you are using DTS OR if ypu want to add data to an excel...

Hi,

Take out "set"

Dim myName

myName = DTSLookups("My_Query").Execute(DTSSource("Sal").Value)

Is this an array? Then

DTSDestination("col001")= myName(0)

DTSDestination("col002")= myName(1)

...

Johnny

Hi

Is this you problem?

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

Johnny...

Hi,

Next time please not put urgent, because maybe is urgent for you but not for anybody else.

Read this article, maybe you answer is there.

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

Johnny

Hi msbolton,

Can you give us more details?

Are you have the rigth permissions to write and delete files on the network.

Are you using map drives?

The FTP tool in DTS is only...

Hi mhweiss,

Two options to setup:

1.Execute Meain on pkg threat and

2.Close connection on completion.

These options are in the worflow properties.

Test again and let me know.

Johnny

HI Dude,

You should have a loop dts to get each file at the time. After bcp the file you can get counts with a select statement and past this to...

What is the error?

What are you trying to do?

Johnnny

What sp do you have on the sql box?

Did you try to reinstall you oracle driver?

Did you check the name of the pkg in the DTSrun line code? make sure...

That error occurs when you have a char or varchar field with specific length and you try to put longer string into it.

Johnny...

Always It's an issue with xp_sendmail, I think it's not reliable tool.

Here is a good tool you can incorporate to you SQL box and forget to have more problems with...