Good topic...I have agreed and disagreed with points in everyones posts so far. I say use what's secure, what performs well enough to support the goal in mind and allow...

srilu_bannu (4/22/2011)

---

I am sorry for not being clear .

This what i did:

1.Right click on the package and clicked variables.

2.to the left of a package you will see variables

3.i have...

I understand the challenge you're facing, but as...

Another drive-by posting brought to us by Syed.

Here again, those values are irrelevant unless they're backed by real licensing purchases, That said, they will always return DISABLED and NULL by...

Thanks for posting back to the thread...it's good to hear what solutions people are landing on.

Sounds like you are in good hands but I am just curious and can't help...

sturner, you and I are on the same track. The article in my previous post deals with the issue.

I can identify with your frustration. I avoid SSIS unless I truly want to do Transformation work that justifies the overhead, but that bar is moving higher and higher for...

Your choice surrounding database security with respect to your application is the...

Sumanta Roy (4/20/2011)

---

Is there any way to find the number of devices using the SQL server? Can we find what kind of license model(Processor License/Server plus Device CALs/Server plus User...

Can you please provide:

1) DDL to create your test tables

2) DML to create some sample data

3) The queries you have tried so far

4) the desired output

If you do not understand...

Can you please provide:

1) DDL to create your test tables

2) DML to create test data

3) The queries you have tried so far

If you do not understand why I am asking...

srilu_bannu (4/21/2011)

---

Hi all ,

I have a requirement to save the source files and maintain history of the files.

I have used File System Task to deliver the file to a directory...

Shamshad Ali (4/21/2011)

---

Hi all experts,

I have to fill a dropdown with all databases which are online and find a table into it. How do I do this? I have to...

Horatiu Ripa (4/22/2011)

---

Suppose that we have lots of tables related to each other, with no cascading on delete.

Is there a way to find out which are the records not referenced...

Selahattin SADOGLU (4/21/2011)

---

Hi Guys,

After migrating data from SQL Server 2000 to SQL Server 2008,when I am doing any a transaction in the table which find out more row on the...