Viewing 15 posts - 6,691 through 6,705 (of 11,676 total)
The SSIS flat file source cannot read this if the columns change each time.
You need to parse this with a script task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 11:55 pm
Posting the actual errors might help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 11:53 pm
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 11:48 pm
Very nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 11:45 pm
SQLRNNR (7/17/2012)
capn.hector (7/17/2012)
Lynn Pettis (7/17/2012)
Really???does not seem to be the same welsh as when i first started posting.
or is it
I have wondered the same thing
Hmmm, so I'm not the only...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 1:50 pm
There's a problem with the column system_date:
"The value violated the integrity constraints for the column"
My guess is you're trying to insert some value that violates a primary key, a unique...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2012 at 1:40 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 17, 2012 at 11:21 am
An oldie but a goodie. Thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 17, 2012 at 11:20 am
Lynn Pettis (7/17/2012)
rodjkidd (7/17/2012)
Lynn you beat me to it! They will just have to hire someone new to fill the B.A. position.
Grant, I did think about you and Murdock but...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 17, 2012 at 11:15 am
L' Eomot Inversé (7/15/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 2:15 pm
Ah ok.
No I haven't created a linked server to SQL2000.
I replied to this thread originally because I know the 2012 native client is unable to connect to 2000.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 2:12 pm
SQLRNNR (7/13/2012)
Koen Verbeeck (7/12/2012)
You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked Server menu?
Koen,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 6:59 am
Tatsu (7/15/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 6:54 am
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 6:51 am
This weekend I'll be trying out the "Chouffe Dobbelen IPA tripel". 9% alcohol, type Indian Pale Ale.
Was nominated as one of the best belgian beers (top 18 of 210 contestants)...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 13, 2012 at 6:08 am
Viewing 15 posts - 6,691 through 6,705 (of 11,676 total)