Viewing 15 posts - 6,481 through 6,495 (of 11,678 total)
W00t w00t, thanks for the 7 easy points Steve.
kaspencer (9/3/2012)
Just a bit too US-centric again.What is Labour Day anyway?
You have an international membership, so you need to be less parochial!
Ken
Labo(ur)...
September 3, 2012 at 5:23 am
Sure! The Execute SQL Task.
Although the Execute TSQL Task may be an option as well, but it's interface is slightly worse than the other.
August 31, 2012 at 6:32 am
Either convert to 2003 Excel, .xls, or use the following method:
Using Excel 2007 files as a Source in SSIS 2005[/url]
Or upgrade to a recent version of SSIS, that's also an...
August 31, 2012 at 12:07 am
Insert data in one table first, get the inserted primary keys, use these to insert in the second table and so forth.
August 30, 2012 at 11:46 pm
Load the Excel file as-is to a table. --> dataflow
Populate the destination tables using TSQL statements --> Execute SQL Tasks
For the record, it would be appreciated if you stated all...
August 30, 2012 at 1:55 pm
In that case it's better to load the initial load from Excel into a staging table and do everything with TSQL from then on.
August 30, 2012 at 7:18 am
Just map only the columns that you need in the OLE DB Destination.
August 30, 2012 at 6:20 am
You can split the name field in a derived column by using a clever combination of FINDSTRING and SUBSTRING.
August 30, 2012 at 12:27 am
How can there be a truncation error when converting from unicode to non-unicode? Both are CLOB datatypes without a length specified.
August 30, 2012 at 12:25 am
You have no other choice. ISNULL is there to check a column for NULL values. You could do it in a script component or in TSQL, but in the end...
August 30, 2012 at 12:22 am
So I guess the wizard.
Do you have a default instance, or only named instances?
August 29, 2012 at 1:42 pm
Viewing 15 posts - 6,481 through 6,495 (of 11,678 total)