In your flat file connection manager on the general tab make sure you have text qualifier set to " or whatever you want to put around text fields. Leaving it...

We loaded the Oracle OLEDB onto the server the packages run from and the developers' machines and set up the TNSnames.ora then used that provider in the dts as it...

I've often found setting the Delay Validation = true sorts a lot of connection based problems.

Don't save the package with a user key in package properties, protection level. Either set "Don't save sensitive" or "Encrypt .... with password" and set a password you can both...

Excel is a pain as it chooses the data type based on the data in the first ten or so rows so US zip codes look like numbers unless you...

Look out Gail, the swallows are coming - I stood on the verandah last evening in south west England watching a sky full of swallows and martins swooping and darting...

The biggest problem I've had with access databases is where they are held and what they contain.

The "I've built this database" brigade invariably store them on a local pc drive,...

I'd prefer to be digging my garden, extending my house and sailing my boats and working on the "leisure" websites I look after - oh no, some of that needs...

Since the dtsx is an xml file, try good old WinDiff. It's quite likely to be on your pc anyway.

Works with anything that can be opened as text and is...

I've always used a dataflow with OLEDB source and OLEDB destination for these transfers with an execute sql task preceeding it to truncate the table. I don't know if it's...

Your boss obviously likes to waste company money and time!

If he's so concerned about people seeing the stored procedures in the database he should tell you to put your time...

Don't be so lazy. These people aren't paid to do your job. They've given...

I get full formal flexi-time and it's brilliant. We clock in and out and have all the procedures in place for offsite work etc. There's 4000 ish employees so it...

So have you genuinely earned the MCITP qualification or are you just another committing the crime of deception?

It may make someone feel grand...

There's no money for conferences in this job and I don't do Saturdays - I've got a life and personal commitments 🙂

If it's weekday and free or cheap I would...