Instead of MkDir consider using the methods available in My.Computer.FileSystem.

Reference:

How to: Determine if a Directory Exists in Visual Basic

How to: Create a Directory in Visual Basic

If you stay with...

I've seen that that behavior before and it was an application issue;in query analyzer it took less than a second to return the results, from the application it took over...

Check that the scope of the variable 'archivefolder' is set to the package. You'll probably have to modify the variable or have an additional one that can be used...

First step is to add a package variable. Then in the Script Task add the new variable name to the ReadWriteVariables property of the task. The variable is...

Barkingdog,

You have a couple options for getting the variable placed in the body. One, leave the MessageSourceType as Direct Input and add an expression that sets MessageSource to the...

Most likely the variables haven't been defined or aren't scoped appropriately. No values need...

This Control Flow will place the query results in the body of the message and deliver only if it contains records.

[Execute SQL Task] ---> [XML Task] -f(x)-> [Send Mail Task]

1)...

Using a linked server and configuring it to use alternate credentials might work; use OPENQUERY instead of OPENDATASOURCE in that case.

The "NT Authority\ANONYMOUS" failed login looks like an...

Setting the ResultSet to XML in the Execute SQL Task is another option that would make it easy to use the results in a Script Task.

Just add "FOR XML AUTO"...

Open up SQL Profiler and use the Replay trace template, filtering on your DatabaseID, before you change your identity column in EM or SSMS. That will show you...

In the SSIS Data Flow you would use a Flat File Source. Configure the sources connection manager to use the "Ragged right" format and mark where the columns should...

In addition to dynamic SQL you could also make use of SQL's ability to do short-circuit evaluation.

In the following example @columns= is evaluated first. Only if it's true will...

Jason,

Here's an example using SQL Compare 6 and SQLCMD to do the refresh.

Scheduling could be done with Task Scheduler and the appropriate credentials.

REM TestingRefresh.cmd

SQLCMD -S TestServer-E -Q "ALTER DATABASE TestingDB...

No, the DSN is a logical name that holds which driver and server to connect to. The DSN name you see in your IDC file just has to match...

Can you login to the SQL server using Query Analyzer with the 'ReadOnlyIntranet' username and run the query that's in your IDC file?

Another thing to check is that the website...