Hi,

I di use use dataflowTask , and went through cursor.

Problem was in executeSql task within dataFlowtask and ExcelTab variable.

When I changed from file name into Create Table .... (using sample...

Hi,

I little change sample, so I use this variables:

1)

FilePath='c:\temp\sample.xls'

(but, I can dynamicly create file name through expression properties, like

"c:\\temp\\test_" + substring((DT_STR, 50,1250) GETDATE(),1,10)+".xls"

if I need file name

c:\temp\test_2008-01-10.xls

EvaluateAsExpression property needs...

Hi,

I finaly did it and it works realy great.

There is one thing I had to change.

I had a problem (or I didn't get it right) with Execute task (to...

Please, can you explane how do you create ExcelFileName and TAB

variable.

I can't see it cleary from the picture.

radovan

Hi,

I just wont to put one free tool. I just can't live without it.

http://sqldigger.bdsweb.be/

This tool search within sql server objects.

Radovan

But, the same problem exists for

SELECT TestTable_ID

 FROM TestTable

 WHERE TestTable_ID = 00000000000000000001