Viewing 15 posts - 12,436 through 12,450 (of 13,849 total)
One guess would be that your PK data in Excel is in numeric format and that your PK on SQL Server is held as varchar(n) (even though it may look...
November 4, 2009 at 1:09 pm
In your Dataflow, there's a Data Flow Transformation called 'Lookup' - that's the one I was referring to. Have fun learning 🙂
November 4, 2009 at 9:43 am
Add a look-up to check whether the PK from your source already exists in your target data. If not, do the create, otherwise ... nothing.
November 4, 2009 at 9:24 am
yosiasz (11/3/2009)
November 3, 2009 at 3:20 pm
No - it should not do that. For some reason, the Excel driver thinks that there is data in the spreadsheet in the preceding rows.
Try recreating the template from File/New...
November 3, 2009 at 2:46 pm
What is the format of the DBF files? Are these database files? What driver are you using to connect to them?
Is the meta data in all the source files the...
November 3, 2009 at 10:26 am
Have you checked the Forced Execution Result (or similar - haven't got SSIS open right now)?
November 3, 2009 at 12:34 am
Of course UTF-8 is supported.
Truncation errors happen (usually) because your source data is too wide for either:
a) The variables they are held in as they pass along the SSIS pipeline,...
November 3, 2009 at 12:29 am
stricknyn (11/2/2009)
There's no CountIff feature in aggregate task? I have data in one of my dataflow columns of my data flow component in which the data is arranged...
November 3, 2009 at 12:25 am
🙂 I'm sorry, but I'm out of ideas. This is simple and there's not much else to check.
November 1, 2009 at 10:08 am
Describing something in an IT process as "not working" is rarely going to give people sufficient information to allow them to help diagnose a technical issue.
October 31, 2009 at 11:42 am
Your assumption is correct, so something else must be happening.
a) Double check the scope of the variables
b) Double check that the variable is actually being set as you think (Msgbox...
October 31, 2009 at 11:36 am
This is also simply achieved with a short piece of script, if you feel like dabbling. This would have the added benefit of not feeling like a bit of a...
October 30, 2009 at 8:25 am
Get that man a beer :exclamation::exclamation::exclamation::exclamation:
I am impressed & will no doubt be checking out this thread again when next I have to import from Excel 🙂
October 29, 2009 at 12:00 pm
No problem & good luck. Too many people have wasted too much time on this Excel data-typing / NULLing issue.
October 29, 2009 at 11:16 am
Viewing 15 posts - 12,436 through 12,450 (of 13,849 total)