Knowledge Hunter (6/23/2011)

---

This is what I am inserting using the following query:

INSERT INTO Test..Test_table VALUES (75968,'???F')

and this is the output when I use a select query: ???F

table script is as...

No log from SSIS by default.

You can setup your Agent job step to capture anything the package execution writes to the console.

Beyond that you'll have to implement your own logging...

I'm not a fan of sentinel values for a lot of the reasons you mentioned. What about having a status column, along the lines of PeriodIsEnded, or something broader like...

b.lam (6/22/2011)

---

opc.three (6/21/2011)

---

I would recommend temp tables here given the expected number of rows (~215K). Te optimizer always assumes a rowcount of 1 for table variables so you have a...

Anytime... Fight the good fight 🙂

For Q2 I would recommend you prevent bad characters as far away from the table as possible as edge-cases like this can wreak havoc on your system, e.g. strip them...

How is your original data table populated?

Have you seen this article yet? http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

Direct replies here: http://www.sqlservercentral.com/Forums/Topic1129499-146-1.aspx

TFS is pricey, but if your org drinks the KoolAid it can replace a lot of disparate tools and I have seen it deliver on its cost. It's a full...

What's the budget? Team Foundation Server Source Control (TFSSC) has got the goods. I have not found it to be super-friendly with SSMS in terms of seemless development-ide/code-repository integration though...

I'll add to the list of non-buffer-pool memory used by SQL Server: memory used by...

I just made the connection to this other post of yours:

http://www.sqlservercentral.com/Forums/Topic1100808-149-1.aspx

Since .NET is not your forté why not use the one-line PowerShell script I provided?

rmechaber (6/22/2011)

---

Looks like you must create a Windows account, grant it NTFS permissions to access the relevant shares, etc., then create SQL login based on the Windows user, etc. ...

Pam Brisjar (6/22/2011)

---

Both my Google and memory skills are failing me so I come to you guys:

I suspect there's a security context difference between running a SQL Agent job via...

.NET class System.Data.SqlClient.SqlBulkCopy

It allows one to load data directly from an ADO.NET data structure into a SQL Server database via the bulk copy API (same one used by bcp I...