That's true, John. Need to read more closely.

It's something like this then:

FINDSTRING(Column,"0",1) == 1 ? RIGHT(Column,LEN(Column)-1) : Column

It's not tested, but that should get you going.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

RIGHT(Column,LEN(Column)-1)

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Hi Subu,

You will need to change the data type on the output of the OLEDB Data Source to something more appropriate for Excel. Most likely a string.

Right click on the...

Teekay,

I only recommended ActiveX as an alternative way with DTS since a file watcher task is not available in 2000/DTS.

Now that you have the FileWatcher and SQL Server 2005 you...

Yes, use an ADO.Net Connection Manager.

Create an object variable.

Put your sp in an execute sql task using the above connection.

Then you can use a Foreach Loop Container to iterate through...

Hi Xu,

A process must still have the xls file locked.

Use this tool to find out which process is culprit.

http://www.microsoft.com/technet/sysinternals/utilities/ProcessExplorer.mspx

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Hans,

How about INSERT INTO Tabel1(field1, field2) VALUES(?, ?)

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Andrew,

BCP is a command line app, so it can be run from the command line. What does database app mean? sql code, vb program...?

Alternatives are the bulk insert command or...

Hopefully this 3rd party tool has a command line interface.

If so, then the Execute Process Task will do the job.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Is this how your package looks?

OLEDB Source -> Lookup -> Destination

It should.

The lookup works differently than DTS. I have had to hook up both the good and error output of...

Assuming that the number of columns and column names will always be the same...

Set up the data transformation with a sql command with a static version of your query.

Change the...

Right click on the Exec SQL Task and click the Edit Breakpoints... menu item.

Enable the break point for the Post Execute event. It should by the second one.

Click OK.

The task...

Hi Manisha,

Where is the data source. Another file or a db.

One way would be to substring in a query.

The other would be to use a derived column task in the...

Hi Pat,

I think the syntax should be:

D:\Apps\90\DTS\Binn\DTExec.exe" /SQL "\Package1" /SERVER servername1

Verify with the DTEXECUI util. Set it up and look at the command line item.

Norman

DTS Pacakge Search

http://www.dtspackagesearch.com/

Hi Alen,

There are a couple options available before going the script task route.

Wildcards: Can you match the two file names with wild cards, * for multicharacter and ? for single...