Not sure if we're...

L' Eomot Inversé (7/27/2012)

---

David Burrows (7/27/2012)

---

With these language problems maybe we should ask Steve to create a new IFCode <sarcasm></sarcasm> to highlight sarcasm including a caveat

'If you take offence...

Reading all these posts today, I feel the need to say something stupid.

"something stupid."

Okay, all better now. @=)

Gus, this issue was solved years ago. It was when I was converting from 2000 to 2005. I posted the solution and someone was just posting a thank you note...

I'm glad my solution has worked for other people. I haven't had this problem in a long time as we are no longer converting DTS packages. Bulk Insert doesn't always...

EDIT: You misread Gail's first sentence. Go back and re-read. She refers to both Clustered and Non-Clustered Unique indexing properties.

As Gail said, the images are useless for us. You need...

BTW, it is not entirely painless. If you have any OLE DB Destinations in a Data Flow Task, you will get a number of SSIS warnings about the FastLoadMaxInsertCommitSize. 2005...

SQL Server has pointers that tell it which indexes refer to which records. Your James names with different IDs won't get lost. However, if you don't have your indexes written...

The answer is configuration files.

I wouldn't use an XML file unless you can put it on a drive where no one else can access it. This seems to call for...

Chaithanya M,

Again, Books Online should have the answer for this question.

Chaithanya M,

I see you have a number of basic SSRS questions that can be answered if you look at SQL Server's native help file "Books Online." As I referenced in...

Do you have access to Books Online? This question is easily answered by looking in there.

Also, Microsoft has a Books Online are that you can find the answer in. Google...

asranantha (7/27/2012)

---

HI friends, i have smal doubt in ssis plz tell me the answers

i have soure table that is sql server table that table name is sample and its...

Is this a one-off or will this be a reoccurring thing?

If reoccuring, will the 20+ records always have the same dynamic format?

Back to the semi-technical discussion...

If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

I'm not speaking in the context of the splitter function. I'm...