i believe i have it.

For /F "tokens=*" %%A in ('dir /B D:\test\filename*.xls') Do Set orgfilename=%%A

then when i call the CMD file that contains DTEXEC using %orgfilename% it works!

Sorry, Elliott.

I'm just learning SSIS and know very little so far.

My Main SSIS Package works fine.

But, I also need to update another table with the FileName, date/time etc of...

I have a bat file that places a File-Name in a VARIABLE (OrgFileName)

set OrgFileName=

dir /B D:\test\test*.xls

echo %OrgFileName%

I then want to use the DOS variable %OrgFileName% in the DTEXEC SET...

Elliott, I'm sure it's no surprise to you that it worked!

I was hoping I could do ALL the processing in one BAT file. I guess I'll have to split things...

Thanks, Roy. That's what I thought, but the Developer is telling me no. I'll check with him again.

I think I fixed my problem. And I have NO idea what the "real" issue was.

I ended up DELETING my SQL DESTINATION and Rebuilding it from scratch. That seemed to...

You question made me think just a little more.

I Googled and found out how to test for NULLs and put that equation in my DERIVED COLUMN test. Then the...

Converted_My_VALUE is a column from an EXCEL file. When I get into it's FORMAT CELL it's defined as GENERAL. It can contain blank or a number..

THANK YOU, Phil !

Between your help and Googling to get some details, this finally worked.

It's easy when you know how. 🙂

...simple for you 😀

sorry, I'm now googling a solution to this error:

"the destination component does not have any availabe inputs for use...

Thanks for responding Hussain27syed.

Here's my situation:

I have an EXCEL spreadsheet with many columns. I am IMPORTing just a few of them into a Database Table. I have ONE remaining COLUMN...

sorry, can you point me to a web example of DERIVED COLUMN? I'm looking and playing around with it. IT, along with all the other "tasks" in BIDS have a...

Thanks, Phil. I did that.

I'm getting error

"Error1Validation error. Data Flow Task: SQL Server Destination 1 [1814]: Columns "InputFileName" and "FileName" cannot convert between unicode and non-unicode string data types."

1) I've...

Thank you, Steve.

1) Then when I do a SELECT on the DATETIME field in the TABLE, I get this:

2010-02-10 08:12:00.000

2) But when I use SSMS and do an OPEN TABLE to view...