Thanks man.

Really simple, I work mostly with financial clients who want to analyse all kinds of things the whole time.

The problem with most of the guys is that they know...

Actually, it was code that I wrote quite a while ago, and I huuuuugely stand under correction.

I am sooooo sorry! I just went and revisited that code, and I was...

Hey Jeff,

Any helpful links? I googled till I was blue as I didnt want to use any form of a cursor but couldnt seem to get away from it.

Would be...

My DTS is very rusty, but I think in the ActiveScript within the transform you could build in validation. But that comes at a price (performance...)

As GSquared suggests, your best...

I am a huge fan of the fact that SQL 2005 introduced pivot and unpivot kind of functionality, but a little bit disappointed that it is only slightly better than...

You would most probably require some kind of scripting.

If I understand you correctly, you want to move a file into archiving with a timestamp, and then afterwards perform some kind...

One approach you may consider is to use a for each file enumerator which simply reads all the files into a control table of some sorts.

From here, you can...

Being a relative "newbie" to SSC, I happened to stumble across it when researching this new product called SSIS some 6 weeks ago.

After initially playing around in the main...

Hey Joe,

Here is an alternative that you may want to consider as well...

If you know what your time periods are (i.e. they reside on your database on a table), why...

Hey,

Enable logging in SSIS (Click on SSIS>Logging).

You can log just about anything that moves at any level from here

~PD

hey,

I am misunderstanding your posting slightly...

Assuming you have created an environment variable which tells SSIS where your package configurations reside, and assuming that within these package configurations (if I am...

hey,

Are you sure your SQL server agent has sufficient rights to be running the package?

~PD

Happy that the suggestion could be implemented

ciao

PD

Awesome post Raj

🙂

I am not sure if mySQL has OLEDB connection, but if thats the case, it would be OLEDB to OLEDB

~PD