Glad to help 🙂

Good article, and well articulated. On behalf of those of us who have been around a while, thanks for the kind words.

I'm sure that most if not all of...

The % is a MOD operator in SQL Server. If you're not familiar with that mathematical function, it will return the remainder portion of a division operation. So,...

From an SSRS perspective, you can set the page size, layout, and margins, but the rest is up to the printer driver. You might try setting up 2 different...

Ryan,

If you are always running this on Sunday and the dates provided are always Sundays as well, you could just do a MOD (%) on the number of days between...

Are the database names always the same from one day to the next? If so, you could use a For Each Loop and create a static list of database...

You'll need to give some more information... in your data you have included "pratyush" and "singh" in the same row but there is nothing in your source data to tie...

Lee,

What you are looking for is the Lookup transformation. This will allow you check the destination table to see if that value already exists. You will need to...

That's how I interpreted his post. That could go wrong in a hurry.

You'll need to provide some more information about what you are trying to do, your environment, etc.

If you're looking for an easy way to create the destination table, you could pull out the first SELECT statement (before the first UNION) and do a SELECT...INTO to create...

Sam, this really depends on the application you are calling, not really SSIS. Most applications that can be called from the command line will allow you to pass parameters...

Bhavna,

Will you be splitting this data based on the meetingcode value? If so, since you have a small number of distinct values you are best using the Conditional Split...

Can you post your script code?

Yes, it is possible. You can use a Conditional Split transform to branch your output to the respective flat file destinations. There are other options, including the Foreach...