Viewing 15 posts - 9,601 through 9,615 (of 13,874 total)
Great! Thanks for posting back.
October 21, 2013 at 1:30 pm
In your flat file connection manager, which 'Format' are you using?
I would suggest trying out 'Delimited' with 'None' as your Text qualifier and {CR}{LF} as your column delimiter.
October 21, 2013 at 1:09 pm
miles_lesperance (10/21/2013)
October 21, 2013 at 1:03 pm
system243trd (10/21/2013)
I am trying to run an SSIS package an install it on a file system - here are the steps...
October 21, 2013 at 1:00 pm
system243trd (10/21/2013)
I have built the package to the bin folder.
When I navigate...
October 21, 2013 at 12:43 pm
It sounds like you are very close to success - well done on getting so far.
Are you able to determine at exactly which point in the dataflow that the padding...
October 21, 2013 at 12:41 pm
Btw, this is totally random. Why is your photo so unhappy ?
That was a good day. You should see me with a hangover.
There are, probably, millions of examples of how...
October 21, 2013 at 12:13 am
blasto_max (10/20/2013)
October 20, 2013 at 11:40 pm
blasto_max (10/18/2013)
Is there a way to cast an input data automatically to the destination column type ?
No.
October 18, 2013 at 11:19 pm
dan-572483 (10/18/2013)
Koen Verbeeck (10/18/2013)
dan-572483 (10/17/2013)
Regarding Access: which provider are you using? JET OLEDB or ACE OLEDB? JET is only available in 32-bit, but ACE has also 64-bit providers available.
The package...
October 18, 2013 at 10:24 am
Have a look here.
October 18, 2013 at 5:16 am
I think that the Conclusion in Koen's blog needs a bit of a tweak. Perhaps something like this?
Only when you want to set up a dedicated SSIS Server will you...
October 17, 2013 at 2:35 pm
etl.laptop (10/15/2013)
Error -
[Execute SQL Task] Error: Failed to acquire connection "MyDBConnection". Connection may not be configured correctly or you may...
October 15, 2013 at 12:19 pm
Should you decide to throw in a Pig and a Donkey as well, I'd suggest resorting to a lookup table rather than expanding out the code to a nesting nightmare.
October 15, 2013 at 11:44 am
Nevyn (10/15/2013)
Phil Parkin (10/13/2013)
...it's still not actually being done by SSIS... it's being done by a script.
Well, I think we are drifting into a grey semantic area here.
SSIS natively...
October 15, 2013 at 11:40 am
Viewing 15 posts - 9,601 through 9,615 (of 13,874 total)