I'm going to risk being contraversial here, but I'd probably agree with your boss...

The execute SQL task has its place and is indeed the fastest way to perform a large...

Hi,

It isn't the flat file destination component that controls the format of the file. It simply controls the mapping.

If you need to have the column in a particular position, use...

Hi Hasysf,

Why don't you just use a variable evaluated as an expression to build your SQL command? Then you can forget about the parameters, and what's better is that you...

Hi,

I haven't tested, but I don't believe you should have any problems as far as waiting for the file to finish transfering. The FTP task won't complete until the transfer...

Just wanted to add a work around for those people who talked about using a waitfor or a time delay to prevent processing of a file not yet ready. I...

What service pack are you on?

There used to be a bug (can't remember when it was sorted), where by the work around was to set the connection manager in...

Hi Venki,

Why don't you connect to your access database using OLE DB for Jet?

Then you can use the OLE DB Destination.

ODBC destination is not supported in SSIS. That is to...

Quite interesting that the non certified folks out there seem to attract a larger salary. I guess management are busy with their MBAs instead of technical certification.

Chart

I'd have to agree with the previous post...

One of the benefits to SSIS, and one of the ways to leverage performance is to transform data in a single pass....

Hi,

It might help to explain a little about what you've posted... 🙂

What constitutes a row? What do all those parameters represent? A bit of background about the source etc etc?

Then...

If you have all the required permissions in your mysql database, then check your package encryption.

Remember that encrypting sensitive with UserKey (this is the default I think) means that other...

There was an excellent article written on this very site about sending query results in email using xml.

Email Article[/url]

Hi Brandie,

If you look in the solution explorer, right click on the project and go to properties, a new box comes up with configuration properties.

If you select the deployment utility...

Hi Brandie,

Not sure about your error message, but I know that when I set my project property "Create deployment utility" to TRUE, it attempts to rebuild every package in the...

I know certain OLE DB sources require different syntax...

http://www.proteanit.com/b/2008/03/18/ole-db-command-for-jet-40-in-ssis/%5B/url%5D

I know this works in access and paradox. Perhaps it will work for you too.