Reporting services and SSIS are two distinct things, two different services.

You can't do this, and I'm not exacly sure why you would want to.

Reporting services only cares about datasets, and...

In your expression Put

(DT_WSTR, 4) DATEPART( "Year", DATEADD("dd", -1, getdate())) + RIGHT("00" + (DT_WSTR, 4) DATEPART( "Month", DATEADD("dd", -1, getdate())),2) + RIGHT("00" + (DT_WSTR, 4) DATEPART( "Day", DATEADD("dd", -1, getdate())),2)

Why not try

select convert(varchar(10), dateadd(dd, -1, getdate()), 112)

Edit Added Convert BOL REF

http://msdn.microsoft.com/en-us/library/ms187928(SQL.90).aspx

Use SSIS

SSIS doesn't have very good tools to do this.

Sure it has the lookup transformation, but it doesn't help with duplicates within the file. And the lookup transform is a hog...

Dim fDay As String

Dim fMonth As String

Dim fYear As String

...

I am very confused about what you are asking.

A report model is a defintion for a data set.

and it resides on the reporting server.

Reports that use that report model are...

Unfortunatelly I don't think RS export works that way.

You can try altering your dataset.

Select (Cast Col1 as char(100)) as Col1, Cast(Col2 as char(25)) as Col2.....

From Mytable

Conditional split is good for this stuff, but it is not very easy for your example in ssis 2005.

If you want to use conditional split you only have the findsting...

using a parameter in a query using ssis is fairly simple.

For every place you want a parameter use a ? in place of a variable name.

The variables are used in...

Why do you need the values to be sequential.

As stated above it is done to prevent duplicates. The database doesn't care or require the Identity column to be sequential.

If you...

There is no Openrowset Connection in SSIS.

You should be able to use an openrowset within an execute sql task

OpenRowset described in books Online

http://msdn.microsoft.com/en-us/library/ms190312(SQL.90).aspx

What exactly are you trying to do?

Post examples...

Merry Christmas,

Get out of the office Early,

and make sure you double check the server and database before you execute that last update statement before you skate out of the office.

:w00t:

Mathew,

What data access mode are you using when pulling data from your source?

are you using "Table or View" or "Sql Command" If table or View, then you should be...

Instead Select the columns link.

you'll See

Row Delimiter {CR}{LF}

Column Delimiter Comma{,} -- Change this to ^