Viewing 15 posts - 10,231 through 10,245 (of 13,879 total)
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
Files?
You mentioned only one in your first post.
January 10, 2013 at 4:24 am
ziako (1/10/2013)
HiI tried both methods but 0 rows were written to the OLE DB Destination 1 (new table).
Is there something I am missing?
Are you saying that it previously wrote...
January 10, 2013 at 3:51 am
mpradeep23 (1/10/2013)
January 10, 2013 at 2:28 am
Apologies if you've already mentioned this - I did not see it when I skimmed the thread - but have you tried running the packages manually in BIDS? (Eek, first...
January 10, 2013 at 1:50 am
mister.magoo (1/9/2013)
Use your...
January 10, 2013 at 1:45 am
mpradeep23 (1/10/2013)
Hii trying call SSIS Package from a Trigger is there any perforamnce issue to the database
thanks in advance
with best regards
pradeep
Based on the limited information provided, my...
January 10, 2013 at 1:43 am
Yes.
In the data flow, after the data source, add a MULTICAST.
Connect one MULTICAST output to the existing table and another to the new table.
January 9, 2013 at 8:47 am
You've been here long enough to know the score. Please provide DDL, sample data and desired output in readily consumable form, as per the link in my signature.
January 7, 2013 at 7:22 am
Create an empty solution and add the .dtsx file to it. Then you'll be able to open it.
January 4, 2013 at 9:45 am
opc.three (1/3/2013)
One technique I have used in the past...
January 4, 2013 at 4:11 am
Viewing 15 posts - 10,231 through 10,245 (of 13,879 total)