Viewing 15 posts - 10,216 through 10,230 (of 13,879 total)
The fact that you need to check all of the rows in the file before deciding whether to commit any of them makes a one-pass solution a little difficult.
I'd be...
January 15, 2013 at 7:18 am
Koen Verbeeck (1/15/2013)
Phil Parkin (1/15/2013)
You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?
To quote the OP:
to perform additional...
January 15, 2013 at 3:50 am
Koen Verbeeck (1/15/2013)
You can use SQLCommand or other relevant classes.
You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?
January 15, 2013 at 3:42 am
kenambrose (1/14/2013)
If using oledb destination in data flow task, the data access mode property...
January 14, 2013 at 11:34 pm
Or if you can use SSIS to achieve whatever it is that you are doing, there is at least one CodePlex add-on that would allow you to use RegEx matching...
January 14, 2013 at 10:41 am
oliver.morris (1/14/2013)
January 14, 2013 at 10:37 am
paul.j.kemna (1/14/2013)
So now that I have found the problem, how do i account for these unknown characters and ignore them so that the rest of the text comes over?
Change your...
January 14, 2013 at 10:31 am
kenambrose (1/14/2013)
Did you consider to...
January 14, 2013 at 9:09 am
There's nothing easy.
But if you don't mind writing some code, you may find that a Script Component Destination gives you the flexibility that you need. Have a look here.
January 14, 2013 at 5:35 am
Do your various destination tables contain different column definitions, or do they all have exactly the same structure?
January 14, 2013 at 5:09 am
If you can make the recordset into a datasource, you can add a script component to make whatever changes you like.
January 12, 2013 at 9:06 am
paul.j.kemna (1/11/2013)
I have an OLE DB connection to an IBM DB2 source. I am trying to...
January 11, 2013 at 8:28 am
I'd suggest exporting the Excel data to CSV format and importing that instead. You'll save yourself a grey hair or two. Mixed-datatype columns in Excel have cost the world numerous...
January 11, 2013 at 12:15 am
mister.magoo (1/10/2013)
opc.three (1/10/2013)
January 10, 2013 at 3:01 pm
Viewing 15 posts - 10,216 through 10,230 (of 13,879 total)