Viewing 15 posts - 10,216 through 10,230 (of 13,874 total)
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
Lidou123 (1/10/2013)
Phil,I will use it like a staging table.
After data in the table, I will use them easily with SSIS and T-SQL.
If the column names and datatypes change every day,...
January 10, 2013 at 2:13 pm
Lidou123 (1/10/2013)
Hi All,I think I found the solution: http://www.sqlservercentral.com/Forums/Topic1232909-2674-1.aspx
But I don't know if it works with excel file?
What do U think ?
It won't work with Excel files without tweaking the...
January 10, 2013 at 1:54 pm
bobd125 (1/10/2013)
January 10, 2013 at 1:44 pm
Lidou123 (1/10/2013)
Phil Parkin (1/10/2013)
Lidou123 (1/10/2013)
Very difficult - SSIS is meta data driven and changing meta data gives it a severe headache.
Also, if your columns change every day, how will...
January 10, 2013 at 7:15 am
Lidou123 (1/10/2013)
Please I need your help.
I have an excel file File.xls that i want to load in a table TempTable. But my File.xls can have columns that change everyday.
I...
January 10, 2013 at 5:00 am
Viewing 15 posts - 10,216 through 10,230 (of 13,874 total)