Flat file source and ConnectionString property

Hi,

i have inherited a SSIS project that was left unfinished by a previous developer. One thing i notice with it is that all the flat file sources in the connection manager have hardcoded paths for the ConnectionString property. I would like to change this so that at least the path, and if possible the file name, are dynamic - i.e. they are determined either by parameters passed into the package when it is run or they are contained within a config file.

Is this possible? Can anyone supply a link to an article or tutorial specifically covering this?

Many thanks

Hi Sluggy

It's simple.

1) Create a Variable called SourceFolder of Package Scope

2) Choose the Value Property of SourceFolder Variable while Setting Package Configuration.

Now it's ready for use in expression.

3) In the Expression builder for Flat File Connection Manager, choose ConnectionString property for the flat file and use the following expression: [User:ourceFolder] + "\FileName.txt"

Thanks

Subhash Subramanyam

Fixed header in Sql Reporting

Hi All,
I have an issue with SQL reports. Once I set FixedHeader Property of Table
used in SQl report TURE. The detail of data getting overlapped on fixed
header of the report.
Is there any way to resolve this?
Thankin advance.
ShaileshSet you header line(s) BackgroundColor to White instead of the default
Transparent.
"Shailesh K" wrote:
> Hi All,
> I have an issue with SQL reports. Once I set FixedHeader Property of Table
> used in SQl report TURE. The detail of data getting overlapped on fixed
> header of the report.
> Is there any way to resolve this?
> Thankin advance.
> Shailesh|||Thanks William...It works well.
"William" wrote:
> Set you header line(s) BackgroundColor to White instead of the default
> Transparent.
>
> "Shailesh K" wrote:
> > Hi All,
> >
> > I have an issue with SQL reports. Once I set FixedHeader Property of Table
> > used in SQl report TURE. The detail of data getting overlapped on fixed
> > header of the report.
> > Is there any way to resolve this?
> > Thankin advance.
> >
> > Shailesh

Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.
|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the list properties? I use the keep together property and all my tables are on the same page.
|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the

list properties? I use the keep together property and all my tables are

on the same page.|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.
|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the list properties? I use the keep together property and all my tables are on the same page.
|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!