That would be totally awesome.

aaron.reese (11/27/2014)

---

@Koen,

Yes, you can check the dtsx packages and their project into source control but the cool things that SCC gives you are negated by the way that BIML builds...

aaron.reese (11/27/2014)

---

BIML has some limitations: build and version numbers are not incremented and the GUID for the package changes each time so putting the packages into source code control has...

kaspencer (11/27/2014)

---

When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St...

MOAR COFFEE! 😀

It's time to allow for moderators (privileged forum users) to be able to delete spam.

Most of the succesful forums/boards/whatever have this. Just not SQLServerCentral.

I think as long as the SQLServerCentral...

Hence the checkboxes 😉

You need to install Integration Services. You can do this with the SQL Server set-up.

You don't need to install SQL Server itself.

Woohoo 7 points! 😎 :w00t:

Happy Thanksgiving to our USA friends.

And don't kill each other tomorrow...

riyaziq (11/26/2014)

---

Thanks Koen for the suggestion.

The query I had in mind was incomplete. It should be like this:

ALTER TABLE [Table Name] ADD AUTOID INT IDENTITY(1,1)

DELETE FROM [Table Name]...

Hugo Kornelis (11/26/2014)

---

Good question, though the explanation is a bit...

riyaziq (11/26/2014)

---

Koen Verbeeck (11/26/2014)

---

riyaziq (11/25/2014)

---

As Lowell pointed out, you are inserting duplicate primary key values into the table which is not permitted.

You need to add a 'Sort' component in your...

riyaziq (11/25/2014)

---

As Lowell pointed out, you are inserting duplicate primary key values into the table which is not permitted.

You need to add a 'Sort' component in your Data Flow task.Right...

Nice question, thanks.

beakdan (11/25/2014)

---

Oh, that's because many of us still have to use procedures executing in versions previous to MSSQL2012.

Thank you for reading...