For starters you'll need to include a GROUP BY on every column in the SELECT list that is not aggregated.

harri.reddy (10/24/2012)

---

no in the file there is no row number

i need to know how to insert data into table which has primary -?foreign key relation.

as you said staging table...

Great question about a function I didn't even know it existed 😀

Duplicate post. Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1376326-391-1.aspx

Interesting question, thanks.

I do wonder how people are supposed to get this right without running the script.

Very interesting, thanks for the article.

There are still some VMs you can download:

http://www.microsoft.com/betaexperience/pd/BIVHD/enus/

You'll need HyperV to run this, but I think it is included in Windows 8.

Just make sure you have enough RAM 🙂

Is your SSIS package the only source for the tables?

If yes, you can generate the IDs yourself in the package and insert them into the tables.

No. SSIS can't handle the changing metadata.

Maybe using the Import/Export wizard can be an option?

Running SharePoint on your 32-bit laptop will be slow. You might want to install Windows Server, as that OS is a bit more efficient in it's memory handling.

What datatype has the FirstName column in SSIS? And especially, what length?

And what is the datatype in the destination? Check the flat file connection manager to find out.

What is the...

You can also check out Cognos Analysis Studio. It has a Cognos Framework under it (sort of like the BO Universe) so it's basically drag and drop as well. Simple...

Thanks for the question.

datey2 (10/19/2012)

---

Reg the peer to peer replication topology We allready configure to node now we add one more node into existing peer to peer replication toplogy.for that any downtime...

Duplicate post.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1362869-147-1.aspx