Jeff Moden (7/26/2012)

---

opc.three (7/26/2012)

---

SSIS places us squarely inside the data pipeline to handle those rows in memory however we like: writing them to a file, discarding them without writing them...

Matt Miller (#4) (7/26/2012)

---

opc.three (7/26/2012)

---

Welsh Corgi (7/25/2012)

---

I was trying to determine which option for importing SQL Server into SQL Server was fastest.

I would have assumed that a Stored Procedure would...

I also neglected to mention one aside to the article with whihc I took issue. The author rated ODBC quite poorly and likely due to the fact that he did...

Welsh Corgi (7/25/2012)

---

I was trying to determine which option for importing SQL Server into SQL Server was fastest.

I would have assumed that a Stored Procedure would be faster nut then...

This is not as much an SSIS question as it is a .NET and Crystal Reports question.

http://stackoverflow.com/questions/1236254/crystal-reports-in-a-pdf-file

Your SQL script will run as is so it is unclear what you are trying to accomplish. You mentioned you created a variable at the package level with the same...

Just the row-by-row error handling itself should be enough to give SSIS a fair look. And yes, SSIS OLE DB Destination w/FastLoad option uses the same bulkload API as BULK...

Proper forum etiquette would be to share your solution so others can learn and benefit too. If you have a moment would you kindly elaborate on what you did to...

SQLSACT (7/26/2012)

---

Hi All

I'm working with a SQL Server where a Specific Login has the sysadmin server role.

Is it still necessary to add the login as a user to the...

TRY

I was following this thread wondering what was the outcome. Thanks for posting back. Happy you got it sorted.

Yes, you can safely add tables to a subscriber database that are not part of the Publication and do not exist in the subscriber database.

Embedded commas in the data are problematic for SSIS.

Here is a good thread to read up on the issue:

http://www.sqlservercentral.com/Forums/Topic1092764-148-1.aspx#bm1194909

GilaMonster (7/23/2012)

---

Stamey (7/23/2012)

---

m_fSeqNo = 384680 m_blockOffset = 23866 ...

What does the boot page say in prod?