If you just want to straightforward copy of the tables try the Import Export wizard from management studio. Right click the source database, select Tasks, then Export data and follow...

When you run under the agent the package is being run by the agent login. When you run from the IDE or management studio it's from your login. Hence you...

It isn't the badly phrased, minimal information questions which make me see red but the posters who, given a line of research or something to try, just say "Just give...

The link should have been

I have found variables in scripts to be case sensitive too so ensure you use exactly the same each time.

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