You can set almost any property of a task by using expressions, for a flat file you want to set the connection string value in the flat file connection manager,...

I recently upgraded from SQL 2005 standard to Enterprise and was as simple as running the setup from the command promp with the SKUUPGRADE=1 flag.

http://msdn.microsoft.com/en-us/library/ms144259.aspx#Upgrade

I assume 2008 is similar, ...

i would use a conditional split to spit out the rows that have invalid dates and then send them to a junk destination.

what determines a valid date, is it...

Though my suspicion is the developer in the background fixed the password supplied by the web app and did not tell me about it. As dropping the login and re-adding...

Slick84 (3/15/2010)

---

Thanks. Found out that it was state 8 which is a password mis-match.

Im confused as I only dropped and re-added the login at the database level and not at...

Thanks Paul, yeah I wouldn't use it in 'real-life' i would tend to go for the ROW_NUMBER example posted

have a look at the error log on the server that you are tying to connect to, this should give you the reason for the failure.

you can also do this without using WHERE by using EXCEPT, though without knowing the order of the data the results may vary

SELECT TOP 700 * FROM yourTable

EXCEPT...

yeah that would be a nice feature

The way i do this, is to disable (right click --> disable) the tasks i don't want to run and then execute the package as a whole. ...

what is the type of data that you are looking up? if it is String data then the lookup will be case sensitive by default and will fail if...

You will need to post the error messages from your publisher, distributor and subscriber.

There will be a reason the subscriber is down and the error logs should tell you that,...

Is this a SSIS package?

If so you can run the package in debug mode in BIDS and set up a data viewer to track the data through the dataflows to...

how are you doing the import?

The price depends on the country you are from but as a rough idea the US prices are here;

http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

I would be tempted to buy a 2008...