In BIDS you would choose Project>Migrate DTS 200 Package.

I think you need another variable with package scope that you can increment with the value of the variable that has RowCount scope.  I believe you would do this using...

I have a situation where I am querying a daily SQL DB snapshot of a large legacy system.  The name of the DB is tagged with the snapshot date, so...

I have not done this - but here are my thoughts.

1 - You need to retrieve the zip file from the secure site.  I think you probably need a Script...

The .rdl is stored in the ReportServer database.  What I generally do is open the report via the web browser, go to the Properties tab, and click Edit.  You can...

From the MSSQL Business Intelligence Design Studio  choose the REPORT > REPORT PARAMETERS menu item where you can add a new param and indicate the data source for the param.

Robert,

Here is what my tech remembers about the Dell server patch:

"I got the updated 64-bit SAS driver for the 1955 Blade"

hth,

Ed

I had a similar issue with a Dell server experiencing multiple memory access violations in a day; sometimes locking up the SQL server; and even blue screening a couple of...

Another option might be to use the Merge Join transformation available in SSIS.  It allows you to perform a join on disparate data sources when a normal SQL query join is not...

Here I think is one way to approach it:

1) SQL Task to set @server into an SSIS variable

2) OLEDB Source to get results of EXEC SP_HELPSRVROLEMEMBER

3) Derived Column to add...

If you store last date queried in a table, you can use a SQL Task to query that table, retrieve the value and assign it to a variable.  You would...

I use Idera's SQLSafe backup utility.  It has worked well for me as far as speed and compression of files.  You can adjust the number of backup threads that run...

If you are using Reporting Services then you most certainly should backup the ReportServer db.  It contaiins all of the critical info for SSRS including report definitions, report security, schedules,...

SSIS has Merge and Merge Join data transformations that might also come in handy here.

Ronda,

The first thing I would look into would be the permissions of the account that is executing the job (the SQLAgent service account).  Does it have access to the network...