Hi,

It's found on the set scripting options page... See screenshot attached.

Thanks,

Simon

That's probably the route I'd go down. Would also be interested in other approaches if anyone has any.

Thanks,

Simon

Or it could be the double quotes in your SA password. Are those necessary? consider using a different secure password.

It's been a while since i've done installs like this but if that's the exact string you're executing, might it be that you've not left a space between the switches?

Looking...

Are you saying that you can't log in with the SA password you set?

So you need to copy 50+ tables....

1) Do you need to do this once, and once only, or is this going to become a regular thing?

2) How many tables are...

Hi,

Here you go:

http://bit.ly/120bYs9

Thanks,

Simon

Hi,

Go to the properties of your parameter, select Available Values from the left, then select the Get values from a query radio button, or specify values. Select the dataset, value...

Hi,

You might be able to make use of the trial version of this:

http://www.apexsql.com/sql_tools_restore.aspx

http://www.apexsql.com/sql_tools_recover.aspx

Thanks,

Simon

Hi,

The creation date/time will give a good indication but i'd say it was worth having a read of the log to see if there is anything in there that may...

No worries... we all have them.

Great!

Hi,

So i've included a screenshot....

There should be an event handlers tab when you open the package. On there you can select an event handler for a particular executable, or the...

Hi

If you're trying to do this in T-SQL then what you need is a case statement.

SELECT

CASE

WHEN value1 = 1 AND value2 = 2 THEN 'A'

WHEN value1 = '1' and...

OK so try doing a "Move File" file system task in an OnError event handler on the data flow.

Thanks,

Simon