Viewing 15 posts - 11,881 through 11,895 (of 13,365 total)
This is really not my area of expertise, but I think that you'll have no problems with the availability of regedit and that gacutil would be installed as part of...
December 23, 2009 at 5:21 am
Not really. Still seems like a versioning issue to me. Did you have to register that DLL on your local PC, or was it just 'there' as a result of...
December 23, 2009 at 4:02 am
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
Viewing 15 posts - 11,881 through 11,895 (of 13,365 total)