Knowledge Hunter (6/23/2011)

---

The data is inserted using Data Manager.

Hence N cannot be added as prefix for the chinese data entered in the batch.

When we are using the query you have...

OK, that was not what I was thinking of. I now have something to go read up on, thanks 🙂

I won't let the cat completely out of the bag, but...

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. ...