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

Defaulting the export option

Is there a way to control the contents of the report export drop down
list? Specifically, I would like to set a default export to PDF
(instead of the "Select a format" entry)You can force the rendering format for that report but I don't think there is
a way to default the drop-down selection.
Here is a PDF render format against the AdventureWorks sample reports (the
report gets generated in PDF):
//localhost/ReportServer?/AdventureWorks Sample Reports/Company
Sales&rs:Format=PDF&rs:Command=Render
"Paul" wrote:
> Is there a way to control the contents of the report export drop down
> list? Specifically, I would like to set a default export to PDF
> (instead of the "Select a format" entry)

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.