Delay Insert

I am parsing a file where along the flow I use a conditional split. One path of the split is the primary table (with IDENTITY) values. The rest of the paths have a FOREIGN KEY to the primary table.

It seems that SSIS is trying to insert the rows at the same time (which makes sense) but this is causing a problem with the secondary tables and their FK constraint since the primary table is not yet written.

Is there a way to delay the secondary tables until the primary table is done?

(I guess one way is to run through the file twice... once for the primary table and another for the rest but that seems wasteful to me...)

Thanks.

There is no way to delay paths inside a data flow, or set any precedence. One option I like is to stage the "secondary" data in a raw file. This is very efficient compared to most source and destination combinations. In your current Data Flow write the secondary data to a raw file then add another Data Flow task, with a raw file source and the your final destination.

Definitions

Hi,
I am wondering if someone can help me, I am trying to find very simple
definitions of what goes into the Control Flow and Data Flow Tabs in SSIS, I
have read a few explanations and it must be that I am not understanding the
definitions correctly as it sounds like you more or less put the same things
in both when I know that is not the case. I know that SSIS is a complete
re-write of the DTS system but if someone could describe the tabs in SSIS
with reference to DTS it would be great!
Any assistance would be much appreciatedPlease check on this site... really good one and sister concern of old sqldts
site.
http://www.sqlis.com/
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"harq" wrote:
> Hi,
> I am wondering if someone can help me, I am trying to find very simple
> definitions of what goes into the Control Flow and Data Flow Tabs in SSIS, I
> have read a few explanations and it must be that I am not understanding the
> definitions correctly as it sounds like you more or less put the same things
> in both when I know that is not the case. I know that SSIS is a complete
> re-write of the DTS system but if someone could describe the tabs in SSIS
> with reference to DTS it would be great!
> Any assistance would be much appreciated

Definitions

Hi,
I am wondering if someone can help me, I am trying to find very simple
definitions of what goes into the Control Flow and Data Flow Tabs in SSIS, I
have read a few explanations and it must be that I am not understanding the
definitions correctly as it sounds like you more or less put the same things
in both when I know that is not the case. I know that SSIS is a complete
re-write of the DTS system but if someone could describe the tabs in SSIS
with reference to DTS it would be great!
Any assistance would be much appreciated
Please check on this site... really good one and sister concern of old sqldts
site.
http://www.sqlis.com/
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"harq" wrote:

> Hi,
> I am wondering if someone can help me, I am trying to find very simple
> definitions of what goes into the Control Flow and Data Flow Tabs in SSIS, I
> have read a few explanations and it must be that I am not understanding the
> definitions correctly as it sounds like you more or less put the same things
> in both when I know that is not the case. I know that SSIS is a complete
> re-write of the DTS system but if someone could describe the tabs in SSIS
> with reference to DTS it would be great!
> Any assistance would be much appreciated

Definitions

Hi,
I am wondering if someone can help me, I am trying to find very simple
definitions of what goes into the Control Flow and Data Flow Tabs in SSIS, I
have read a few explanations and it must be that I am not understanding the
definitions correctly as it sounds like you more or less put the same things
in both when I know that is not the case. I know that SSIS is a complete
re-write of the DTS system but if someone could describe the tabs in SSIS
with reference to DTS it would be great!
Any assistance would be much appreciatedPlease check on this site... really good one and sister concern of old sqldt
s
site.
http://www.sqlis.com/
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"harq" wrote:

> Hi,
> I am wondering if someone can help me, I am trying to find very simple
> definitions of what goes into the Control Flow and Data Flow Tabs in SSIS,
I
> have read a few explanations and it must be that I am not understanding th
e
> definitions correctly as it sounds like you more or less put the same thin
gs
> in both when I know that is not the case. I know that SSIS is a complete
> re-write of the DTS system but if someone could describe the tabs in SSIS
> with reference to DTS it would be great!
> Any assistance would be much appreciated

defaultcodepage is set to false

when ever i drop a ole db source or destination control on data flow, upon clicking to edit it complains about -- defaultcodepage is set to false. When i check in the properties and set it to true; i get no error. What is it all about?

kushpaw

codepage has to do with whether your columns in the table have data that are in other languages.... seting it to true will ask SSIS to take the defualt translation that it thinks fits your data.