[font="Tahoma"]

Hello Gail,

I have attached the text plan in original post.

Below is the xml plan (from dev).

What I hear from the DBA, that the hardware configuration is pretty much same. The...

[font="Comic Sans MS"]

Thanks!

I am going to do that too!

Meantime I am removing 4 columns on pipeline which will always be fixed string and see if this helps anyway.

Let me thank...

[font="Comic Sans MS"]

Brett,

Thanks for the quick reply.

Problem is - I don't have the control on the environment I am working and I am not allowed to use any custom...

[font="Comic Sans MS"]

This is an excellent article.

However - I am facing a peculier problem that sometime the generated MD5 hashval is NOT same for the same data. This is happening...

[font="Comic Sans MS"]

Why don't you click the first 2 result of the link below:

:w00t: Answer :w00t:

[/font]

[font="Comic Sans MS"]

Another option - a change anyway on flatfile - to add a text qualifier. Example ""

"123";"John Adams";"123 Fake St";"some data goes here; but it has a semicolon in...

[font="Comic Sans MS"]

This will help you. See here![/url]

[/font]

[font="Comic Sans MS"]

I do it exactly as da-zero mentioned.

[/font]

[font="Comic Sans MS"]

See this.

[/font]

[font="Comic Sans MS"]

I guess the files have same extension like *.txt. Use for each loop to loop through files.

Example

Then you can use a script task to move...

[font="Comic Sans MS"]

Script Task or Execute Command task.

See here .

[/font]

[font="Comic Sans MS"]

Questions:

1) Does the SSIS package fails? Or just skip loading few files?

2) If they SSIS package doesn't pick few files (without failure) - what happens when you restart...

[font="Comic Sans MS"]

Or you can add 'execute package task' (pointing to 2ng ssis package) in the first ssis package which will run on success of the end task of first...

[font="Comic Sans MS"]

Can you replace the sql statement to something like 'select getdate()' and see if this still hangs?

[/font]

[font="Comic Sans MS"]

I meant to say - when you don't disable the component, does this sql statement ever gets executed at the first place? You can see the progress bar...