Viewing 15 posts - 12,841 through 12,855 (of 13,849 total)
Create a variable, say RowCount (int32).
Add a Row Count transformation immediately after your source component and map the row count result to the RowCount variable you just created.
Then use precedence...
April 29, 2009 at 8:28 pm
What you are trying to do is not straightforward, as you have found.
One way is described here, under Self Modifying Packages in SSIS?:
April 29, 2009 at 8:07 pm
Is this relevant:
April 29, 2009 at 10:51 am
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
Viewing 15 posts - 12,841 through 12,855 (of 13,849 total)