Low = 4

This link contains code for an Active X Script Task in DTS to do what you want. It shouldn't be too hard to put in a SSIS Script...

Double-check the scope of your variable, making sure there is not a variable with the same name scoped at the package level and the Foreach Loop container level.

Yes.

The function you need to use is Asc.

In the General tab, set Result Set to "Single Row"

In the Result Set tab, click the Add button to add a result and select your variable from the Variable Name...

Have you tried using the ISNULL sql function?

You can do this with a derived column, assuming the value you want to capture is always preceded with an equal sign and followed by a semicolon.

Here's the syntax that...

Is the machine it's failing on 64 bit?

There is no 64 bit driver for Excel.

See links for more information and a workaround.

http://technet.microsoft.com/en-us/library/ms141766.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a4fc47b9-d029-4e7c-952d-9e9f666cf2e8/

Verify the schema the table belongs to is correct. If you created the table, it may have been created with your username as the schema.

It's been a while since I've used an ActiveX script task in DTS, but I remember not being able to specify the types of your variables.

Change your 2nd line of...

Here's the Expression syntax that will work if you're trying to accomplish this in a Derived Column transformation:

(DT_I4)((DT_STR,4,1252)YEAR(GETDATE()) + RIGHT("0" + (DT_STR,2,1252)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)DAY(GETDATE()),2))

You could try the code in this example: http://devhood.com/tutorials/tutorial_details.aspx?tutorial_id=469

I think it would be far simpler to just add a Data Conversion task after your Flat File Source...

The first question you need to answer is what to do with records that don't have a matching Department in your TBL_DEPARTMENT table. Can you ignore those records,...

Look at the Progress tab in BIDS. Scroll through the information and you'll see Start, Finished, and Elapsed time for each task.