Viewing 15 posts - 9,601 through 9,615 (of 13,880 total)
Collate is relevant for strings, not numerics. You need to remove it from the bigint.
October 22, 2013 at 11:31 am
aaron.reese (10/22/2013)
I have a flat file which gets written in three parts (generic header, specific lines, generic footer with a rowcount from the lines). We experienced a 1:1000000 error...
October 22, 2013 at 5:04 am
dan-572483 (10/21/2013)
October 21, 2013 at 2:10 pm
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
Viewing 15 posts - 9,601 through 9,615 (of 13,880 total)