Viewing 15 posts - 1,471 through 1,485 (of 3,666 total)
jcrawf02 (10/11/2010)
A novel way to annoy your spouse and get your geek on each breakfast
You want that toasted?
October 11, 2010 at 11:21 am
I vote for the data conversion route, regardless of whether the user has the proper rights to the Access database. This way, there's no danger of "breaking "anything.
October 11, 2010 at 10:33 am
Take a look at DTExec and DTExecUI.
October 11, 2010 at 10:17 am
Fuzzy Lookups is not supported in the Standard Edition for either SQL 2005 or 2008.
October 11, 2010 at 9:55 am
saurabh.deshpande (10/11/2010)
But, Connection Manager still not working.
It's not upgrading SQLNCLI.1 SQLNCLI10.1
Have you tried manually rebuilding...
October 11, 2010 at 9:11 am
Jeff Moden (10/10/2010)
Alvin Ramard (10/7/2010)
Jeff Moden (10/7/2010)
I may be in a minority here. To me, SSIS is a four letter word. 😉
There's nothing wrong with SSIS, but there are...
October 11, 2010 at 8:08 am
Maybe I should try again with a smaller packet size?
October 11, 2010 at 8:02 am
da-zero (10/11/2010)
Phil Parkin (10/10/2010)
Sorry, but I am not prepared to help you get a job based on lies about your experience.
I must say, I admire your patience 😀
(5 replies and...
October 11, 2010 at 7:58 am
cvandevoorde (10/11/2010)
I started off the project using the import wizard, and nvarchar is what it used. I changed it to nchar, but it looks like I will be changing...
October 11, 2010 at 7:48 am
Phil Parkin (10/11/2010)
the.hank (10/11/2010)
Thank u all for ur suggestions. I have made a single ssis package and a single job and been able to tranfer data.Bravo! 😎
Well Done! ...
October 11, 2010 at 7:30 am
Samuel Vella (5/11/2009)
Even if the data was sorted in the text file SSIS will still want to...
October 10, 2010 at 8:29 pm
I would normally say that you only ask one question per thread. In this case, you helped me a bit and now I only have to say this once...
October 9, 2010 at 2:58 pm
GilaMonster (10/9/2010)
Please don't cross post. It just wastes peoples time and fragments replies.No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1001678-1291-1.aspx
Not only is cross posting a bad idea,...
October 9, 2010 at 11:56 am
da-zero (10/9/2010)
Alvin Ramard (10/8/2010)
October 9, 2010 at 8:12 am
There might be a simpler solution that you miight want to try before doing the .NET stuff. Try either just CR or just LF as the row delimiter, if...
October 8, 2010 at 2:47 pm
Viewing 15 posts - 1,471 through 1,485 (of 3,666 total)