Smendle (5/3/2016)

---

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the number and...

mitra.itha (5/3/2016)

---

Hi All,

I have an urgent requirement in SSIS Package , I want to get the table list from a configuration...

What special functionality does this assembly give you? Perhaps there's been a change in assembly name.

First things first: protect the data. Get him to get backups and to restore them on another server to verify them.

Then ensure that regular backups are in place.

Then think about...

Is there a file called Detail.txt in the SQL Server setup log folder? If so, please post its contents.

You mean this[/url]?

ganapathy.arvindan (4/29/2016)

---

Consider my count is 30

using while loop i am decrement it..till it reaches zero

count =30

then output should be

Empid empname...

Brandie Tarvin (4/29/2016)

---

I hope someone can assist me. I'd like to know where I can find the code behind the SQL engine's "Script AS" choice in the right-click GUI menu....

Most SSIS packages will not run on SQL Express. You'll need a higher version.

Please explain why you are doing this.

Also, you first talk about inserts, then later updates as though they are the same thing. They are not.

I had a similar experience to you with table variables & replacing these with temp tables solved...

Does anyone have The Ball today?

mbraman (4/28/2016)

---

The data I presented is pretty much it.

I want to be able to query for a total for the year 2016 without it adding up all 4 rows. ...

mbraman (4/28/2016)

---

I will first of all draw out my issue:

EmpID Date FieldName FieldValue Total

1234 ...

At least you didn't get this.