only4mithunc (4/24/2012)

---

Hi All,

I have tried 2 options

Option 1. After the DFT I have used a File System task to copy the file to the required destination location. This worked successfully...

What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you cannot store those in SQL Server...

It could be a lot of things. Those two batches are very different. It may have something to do with the fact that you're importing one as a BLOB and...

opc.three (4/19/2012)

---

GilaMonster (4/19/2012)

---

That gets...

Great, that sounds like what I was thinking...something simple to get someone started on the technique with screenshots of the SSIS design environment and steps to achieve.

Just to clarify because...

Steve Cullen (4/24/2012)

---

opc.three (4/24/2012)

---

Steve Cullen (4/24/2012)

---

If the only thing that changes is the database name, you could create a synonym. I wouldn't do that in a function, but you...

MisLead (4/23/2012)

---

I have no knowledge on c#. However i have the following code below that converts double byte to unicode. My requirement is reverse engineering i.e convert unicode (non english...

Steve Cullen (4/24/2012)

---

If the only thing that changes is the database name, you could create a synonym. I wouldn't do that in a function, but you could do that...

Can you post the DDL for FileVersionTable? ...interested in knowing the data type of FileContent.

Also, let me back up one step...can you confirm where in the stack you're receiving the...

Steve Jones - SSC Editor (4/23/2012)

---

Looking for an article on how to import a file automatically into a database using SSIS and the File Watcher Task. Assume some business person...

Compression ratios achieved are completely dependent on data composition, i.e. if the data in your IMAGE columns are jpeg images, or some other highly-variable binary data, chances are you will...

Since you're talking SSIS is it safe to assume the source and destination are on different instances?

Proceeding with that assumption...

How big are the tables? If the source is of non-trivial...

Database...

What does your webservice do to load the file into SQL Server?

On your 67 million row table what is the page count and frag % at index level 1? and 2?

Do you have pad_index set and fillfactor set to a #...