Viewing 15 posts - 12,391 through 12,405 (of 13,874 total)
What does the Script Task do?
December 23, 2009 at 1:11 am
But version 10, as referred to in your error message, is Excel 2002 (see here).
At what point is the error message appearing? Is it when you try to run the...
December 23, 2009 at 12:41 am
Version 10 is Excel 2002, I think. Is that what you have on your PC? You need to get these versions in order ...
December 23, 2009 at 12:23 am
Jeff Moden (12/22/2009)
Heh... I probably wouldn't use SSIS for such a thing. I damned sure wouldn't use a script for this. T-SQL would do the job just fine.
So ......
December 23, 2009 at 12:05 am
Does the server have Excel installed?
December 23, 2009 at 12:03 am
Sabyasm told you already - what is wrong with that method?
December 23, 2009 at 12:02 am
Well, within reason, but if you're going round pretty much the same loop 20 times, I would be doing a fair amount of investigation to avoid having 20 dataflows.
A foreach...
December 22, 2009 at 3:26 pm
From your screen shot it is difficult to distinguish between long lines (which have wrapped) and true line breaks. Can you widen it to make this clearer? Or just cut...
December 22, 2009 at 8:09 am
The result of a union can be thought of as a single table with x rows and y columns with various datatypes - you can't mix and match within that...
December 22, 2009 at 7:06 am
The size of the source field (in SSIS) needs to be increased to accommodate the maximum string length from Excel.
If you then want to truncate this before it gets loaded...
December 20, 2009 at 8:12 am
Is your solution complex? Are there many packages?
You could just create a new solution and import the packages into that.
December 16, 2009 at 4:13 am
born2bongo (12/11/2009)
Not a lot of forum interest in this one atm, ...
Just for your future information, there are several contributory reasons for the lack of answers, I suspect.
1) Your...
December 11, 2009 at 3:35 am
Excel and SQL Server have different dates for 'Day 0'.
In Excel, it is 1900-01-00 and in SQL Server it is 1900-01-01. That accounts for one day's difference.
The other day I...
December 11, 2009 at 1:46 am
Surely if it's temporary, it will not exist at design time and therefore how could SQL Server know about it?
What are you hoping to use the temp table for?
December 10, 2009 at 11:38 am
Maybe you could do the copy and then just add the PK constraint back in with some T-SQL at the end ...?
December 10, 2009 at 9:27 am
Viewing 15 posts - 12,391 through 12,405 (of 13,874 total)