Viewing 15 posts - 11,401 through 11,415 (of 13,874 total)
sanvekar (5/24/2011)
In DFT Add task "Flat File Source" and point it to your input text file.
After that Add a task...
May 24, 2011 at 2:14 am
Now all you have to do is replace all occurances of "Jef" with "Jeff" and you'll be golden. [Wink]
..and all occurrences of occurance with occurrence 😀
May 21, 2011 at 10:49 am
Ah yes, seen that one many times - well done on figuring out the answer. As the flow can go down either (but not both) paths, each of those constraints...
May 20, 2011 at 8:23 am
I agree - a jpg image of the package control flow screen might be helpful.
May 20, 2011 at 7:35 am
Anjan Wahwar (5/20/2011)
--Though this approach is not good performance wise, but you dont have any other way to do the same without any primary key.
One possibility I thought of was...
May 20, 2011 at 3:40 am
Lowell (5/19/2011)
here it is, i think: []bJeff Modens "Replace Multiple Spaces With One" Article[/url][/b]
Same link as mine;-)
May 19, 2011 at 2:42 pm
May 19, 2011 at 2:23 pm
What do you want to happen?
1) Do you want to delete all the rows and re-load them? If yes, just truncate the destination table before doing the load.
2) Or not...
May 19, 2011 at 2:16 pm
nikishh9 (5/19/2011)
i load the data from Staging database to Poststaging but when run package two time at that time i got same rows two time or if i run...
May 19, 2011 at 8:55 am
Can you give some background on what you are doing - what method are you using to run DTEXEC?
May 19, 2011 at 3:22 am
peter.row (5/19/2011)
Using dynamic SQL like this is equal to the last S in KISS - Stupid!SQL Injection attack waiting to happen.
And your secure alternative solution is?
May 19, 2011 at 2:12 am
raj_shekar2005 (5/18/2011)
May 18, 2011 at 1:46 am
This might be a long route ...
I'm afraid it is a bit 🙂 Nonetheless, glad you got there in the end!
May 17, 2011 at 10:02 am
Viewing 15 posts - 11,401 through 11,415 (of 13,874 total)