Viewing 15 posts - 1 through 15 (of 150 total)
[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"]--
Sabya[/font]
November 27, 2012 at 2:51 am
[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"]--
Sabya[/font]
September 2, 2010 at 2:12 pm
[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"]--
Sabya[/font]
September 2, 2010 at 1:44 pm
[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"]--
Sabya[/font]
September 2, 2010 at 10:22 am
[font="Comic Sans MS"]
Why don't you click the first 2 result of the link below:
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
June 25, 2010 at 2:35 pm
[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"]--
Sabya[/font]
June 25, 2010 at 2:29 pm
[font="Comic Sans MS"]
This will help you. See here![/url]
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
June 25, 2010 at 9:12 am
[font="Comic Sans MS"]
I do it exactly as da-zero mentioned.
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
June 25, 2010 at 9:10 am
June 25, 2010 at 9:08 am
[font="Comic Sans MS"]
I guess the files have same extension like *.txt. Use for each loop to loop through files.
Then you can use a script task to move...
[font="Comic Sans MS"]--
Sabya[/font]
June 25, 2010 at 9:04 am
[font="Comic Sans MS"]
Script Task or Execute Command task.
See here .
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
June 25, 2010 at 8:56 am
[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"]--
Sabya[/font]
June 25, 2010 at 8:45 am
[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"]--
Sabya[/font]
June 16, 2010 at 8:23 am
[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"]--
Sabya[/font]
June 16, 2010 at 8:14 am
[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...
[font="Comic Sans MS"]--
Sabya[/font]
June 16, 2010 at 7:33 am
Viewing 15 posts - 1 through 15 (of 150 total)