Viewing 15 posts - 12,451 through 12,465 (of 13,870 total)
I have a couple of Excel suggestions for you:
1) When entering numeric data that you want to to be treated as text, enter a single quote as your 1st character....
November 5, 2009 at 8:20 am
Can you post the exact syntax of your expression field - sounds like it may need a tweak.
November 5, 2009 at 2:06 am
You have made a statement without asking a question, leaving us to guess.
Are you saying that the problem does not happen unless you are in debug mode, or is it...
November 4, 2009 at 2:54 pm
Formatting as text does not affect how Excel holds data.
Specifically, if you format a number as text in Excel and then import it, it will still come in as a...
November 4, 2009 at 2:37 pm
Elliott W (11/4/2009)
You use a derived column task to get it into the pipeline and then you can select it in the data conversion task.CEWII
Beat ya! 🙂
November 4, 2009 at 1:31 pm
Create a derived column & set it to the value of your variable before firing through data conv ...
November 4, 2009 at 1:11 pm
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
Viewing 15 posts - 12,451 through 12,465 (of 13,870 total)