wouldn't SSIS yell and gives an error for...

I'll add my input...

1) I have opened the existing packagee of SSIS file of 2005 version in sqlsever 2008 BI studio and it looks like the version has upgraded.How do...

Check that out...

http://www.ssisdocumenter.com/

also there's another tool from pragmatic-works, but it's more fancy, it uses a sql table to log the stuff in.

I don't really understand what you're trying to do.

can you explain more..

Make sure the package is not using PACKAGE CONFIGURATIONS and reading the connection string out of that.

Amir, you'll use execute SQL task and use your SQL query.

how to use transactions?

I personally use this method, it works and it's controlled well, I never had any luck with SSIS transactions

http://consultingblogs.emc.com/jamiethomson/archive/2005/08/20/SSIS-Nugget_3A00_-RetainSameConnection-property-of-the-OLE-DB-Connection-Manager.aspx

So shall i include all these queries...

There must be a problem with the your permission to deploy reports to the server, or the project and server location is incorrect (I know you said you checked it)...

Hi,

I've blogged your solution here

Basically what you need is a "foreachloop" to iterate over your files, get the file creation date using a script task, use the precedence...

Hi,

I'm having the same problem and Ive sybase client installed, so what path variables you're talking about here and how to change it?

Thanks

Hi,

You can start with that...

it's actually so simple.

http://technet.microsoft.com/en-us/library/ms166358%28SQL.90%29.aspx

is that's what you want?

SELECT

count (*)

FROM

(SELECT DISTINCT

PERSONID,

GENDER

FROM DATASET)

Hi,

Please post your query.

Thanks so much, great article....

I use the evaluation version of this tool

http://www.ssisdocumenter.com/

it's suffecient...just adds a footer "powered by blah blah..."

also there's a commercial one by BIdn.com

http://www.pragmaticworks.com/products/business-intelligence/bidocumenter/default.aspx

do you know any free...