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?

Jeff Moden (7/23/2012)

---

🙂

Did you ever pick through that SSIS package I handed over to a poster a while back, the one that processed a flat file with a header...

Jeff Moden (7/22/2012)

---

But, by bringing it up and since I'm one to call Powershell from xp_CmdShell, it does seem...