Viewing 15 posts - 9,601 through 9,615 (of 13,874 total)
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
g_demetriou (10/15/2013)
is there a way via SSIS to create a table to match a file's headers (which can change), and then load that data into the table? I've been looking...
October 15, 2013 at 2:52 am
I’m using c# code from a SQLcentral article- Using XML from data variable option in SSIS (http://www.sqlservercentral.com/articles/SQL+Server/97947/) which works perfectly with the original webservice address but when I change the...
October 15, 2013 at 2:22 am
If you've processed a file with a dynamic name, you must already have the file name in a variable. Use that in the FST.
October 15, 2013 at 12:17 am
Viewing 15 posts - 9,601 through 9,615 (of 13,874 total)