Viewing 15 posts - 12,871 through 12,885 (of 13,876 total)
Maybe you are getting confused.
The Copy Column transform creates an in-memory copy of a column in your data source, which you can use later on in your data flow.
It does...
April 29, 2009 at 10:10 am
It's really easy.
On your Data Flow pane, add a lookup transformation.
Connect the output of your flat file source to it.
Connect it to the next task on your data flow...
April 29, 2009 at 6:26 am
So the package itself cannot be re-opened? That's quite different from the problem with an Excel source being open at run time.
Can you paste the error message that you are...
April 29, 2009 at 5:46 am
happycat59 (4/28/2009)
What is wrong with using the SSIS Lookup task ? It does exactly what you need.
I agree - Lookup is better - why didn't I think of that?...
April 28, 2009 at 10:04 pm
Sounds like a MERGE JOIN transformation might give you what you want, taking as inputs the spreadsheet and the parent table and configuring the join as you have detailed ...
April 28, 2009 at 8:15 pm
Reading between the lines "Close the open file and rerun" would appear to be the resolution in this case.
April 28, 2009 at 8:05 pm
Try adding a Data Viewer to confirm that the dodgy data is not being returned by the SP.
April 28, 2009 at 7:37 pm
For some reason, all of your source data is being treated as text. If source data is properly recognised as numeric, the text qualifier will not be applied to it.
To...
April 28, 2009 at 7:33 pm
OK, good - that makes it clear. I can think of two ways:
1) Import your data to a staging table in SQL Server and then use a UNION query to...
April 28, 2009 at 7:20 pm
OK, I misunderstood the requirement.
Can you give sample before (source) and after (required format) data please - just one example should be enough for me to picture it - thanks.
April 28, 2009 at 6:08 pm
Add a derived column transformation after the merge to give you the data as you want.
April 28, 2009 at 5:27 pm
Derived column works well.
Create a new column with a formula like this:
[SourceTextDateTimeField]
and give it a datatype of DT_DBDATE. This casts the string to a date and strips away the time...
April 28, 2009 at 1:55 am
You will have two dataflows appearing on your Control Flow - simply join (a) to (b) and you can be sure that (b) will execute after (a).
Not sure that helps...
April 28, 2009 at 1:17 am
If your flat file date format is already in the format
YYYY-MM-DD HH:MM
it is in perfect shape for loading direct into a SQL Server datetime field and you should be able...
April 28, 2009 at 1:00 am
Unless you post sample data, as ruizeddy already requested above, no one will be able to give you detailed help.
April 28, 2009 at 12:06 am
Viewing 15 posts - 12,871 through 12,885 (of 13,876 total)