Why are you converting it to a string to do the comparison?

And if you absolutely have to convert to to a string you would need to do a yyyymmdd format...

If the most granular you can get is day, what happens when there are multiple possible matches?

Can't you get the HostName from a trace of who is running alter view statements on that view? Then possibly track down the actual physical computer doing it? ...

If you want to save the package to the server you'll need to have Integration Services installed and running on the server you want to save it to.

This might be kind of silly but just alter the procedure with all the code commented out, that will effectively disable it, then when you want to turn it back...

Is there a particular reason you have to install it as an update as opposed to just a new instance with 2008 then migrating the databases over?

It sounds...

IT researcher (9/9/2014)

---

ChrisM@Work (9/8/2014)

---

IT researcher (9/8/2014)

---

I am using Import and export data option to import data from one database to another database. Both database have similar structure of...

If you're using the import export wizard in Management studio when you are running the wizard when you are selecting the column mappings(after selecting the source and destination) on the...

Can you just not import that column? That should let the identity column on the destination table work like it's supposed to.

This might be a stupid question but are you using text qualifiers in your input file? If so is the input file formatted properly for those last few fields?

How exactly is the application set up?

Keep in mind unless the application is actually connecting their computer directly to the database, which sounds like isn't the case, all...

Well... then it's kind of their end not to screw it up.

The logic seems straight forward enough at least to check for the company ID, as pointed out though some of the other flaws with this such as what happens when...

Ramana, null is not the same as an empty string. Try, IsNothing(Fields!name.Value)

Keep in mind NULL in the database is not the same as an empty string '', reporting tools will show NULL as a blank space because they don't really know...