Viewing 15 posts - 12,421 through 12,435 (of 13,838 total)
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
🙂 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
Viewing 15 posts - 12,421 through 12,435 (of 13,838 total)