Hi,

Thanks for the speedy reply.

The database is not set to read_only.

All users are restricted to db_datareader access. Only "Select" queries are run against the database. No users are permitted...

Hi ...

This may be a silly question, but how does one use the dbo.Hierarchy table ?

Thanks.

Yo Dude!

Great post. Thanks for sharing!

🙂

Hi,

We use SHA1 and store the result as Varbinary(MAX).

Do you see any problems with this ?

Thanks

Hi ....

In our datawarehouse environment we have added the fields ExtractDate, LatestEntryIndicator, EntryStartDate, and EntryEndDate to all dimension and fact tables. Using these fields we are able to rollback the...

Hi ...

How does one set the ForceExecutionResult property via an expression?

I have tried setting the value via the Expression Builder to "Failure" which does evaluate successfully but when attemping to...

Hi Guys ...

I am experiencing a similiar problem. We have many packages that use a single dtsconfig file. It seems that every connection that has been defined in dtsconfig needs...

Hi ...

The reason for converting to upper case is that often users make changes to the data by simply adding the same details in all capital letters (for various reasons)....

Hi ...

I am currently using a similiar method in order to compare data. The Hash value is calculated as follows:

HashBytes('SHA1',

UPPER(Isnull(convert(varchar(max), Branch), ''))

+ UPPER(Isnull(convert(varchar(max), VendorID), ''))

+ UPPER(Isnull(convert(varchar(max), VendorName), ''))

+ UPPER(Isnull(convert(varchar(max), VendorTradingName),...

Howdy ...

I have not really done much investigation into R2.

We have just upgraded to SQL 2008 from SQL 2005. With our workload, I do not see us moving to R2...

Hi ...

Thanks for the responses.

It seems that SQL 2008 SSIS has had a number of changes to the behavior of its components. This is quite a departure from the way...

Hi there ...

I am experiencing the exact same problem.

Initially when I executed dtexec.exe the following message was returned:

The SQL Server Execute Package Utility requires Integration Services to be installed...

Hi ...

Thats an interesting article and the issues you bring up seem to have merit. If you plan to give examples of problems, I'd recommend you also provide the...

Hi all...

Thanks for the replies. The comments are really insightful.

The problems in our MIS environment are numerous. They range from political to technical. I personally do not have control...

Howdy..

I would agree with Scott. We have an application to capture client details and with that goes a number of addresses and telephone numbers (Home, Work Postal, next of kin, personal reference,...