Please post the full text of the error message you are receiving.

And I quite like Consolas because that's what Visual Studio uses. Not sure that you'll get a consensus here. But I do agree with Anthony about the colours - I...

I like happy endings, good work 🙂

Can you post a screenshot?

higgsboson99 (6/12/2012)

---

Thanks, I got it working and am now able to observe the values being set in the Watch window. The backslashes are getting doubled up. Is this...

higgsboson99 (6/12/2012)

---

Here is the code I am using to set the variables. Am I assigning values correctly? (I know values themselves are correct.)

Public Sub Main()

...

higgsboson99 (6/11/2012)

---

Hi all,

I'm new to SSIS. I've created a data flow task that will import an Excel (.xlsx) file into a database on my SQL Server. The filename...

Do you mean DTS or SSIS?

Probably.

You've been here long enough to know the score - please provide sample input and output data etc etc.

tbraithwaite (6/8/2012)

---

I've also just discovered that if I give the full path to the source DB and run the query from that DB is also gives the leading zeros.

Rather strange,...

Sorry, but thank you for making me laugh with this sign-off :w00t:

Your post is one of the least clear I have read in quite a...

Please follow the link in my signature - it describes how best to post such questions.

Unless you provide more details, it will be very difficult to provide you with...

Does the Excel file already exist? I think it needs to. Stick with CSV if you can and save yourself a few headaches 🙂

opc.three (6/5/2012)

---

I do not think you can delete Excel data using an OLE DB connection but I read you can use the DROP TABLE followed by CREATE TABLE syntax to...

Please answer my other questions and justify the use of SSIS.