Just out of interest, how are you going to keep the EmplIds in sync? Seems like there might be more to this than just syncing e-mail addresses.

Can both systems update...

I've never been brave enough to try that option out, just in case something got 'upgraded' inadvertently 🙂

Try using an OLE DB\SQL Native Client connection instead.

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...