Hi There

Seen this one a few times

You need to go into the Advanced portion of the Flat File connection Manager and define the columns as Unicode string [DT_WSTR] as your...

at one place I worked, we had a manager who would call up every new starter and go into a long diatribe about how great is was for them to...

Been on the receiving end of some of these

i.e. Left Handed Screwdriver (I tried 5 hardware stores before someone took pity on me)

Got my own back though, Was sent out...

Just a quick add on - All of these scenarios do not cover the use of the enterprise level of citrix software. Although it still relies on the main database...

Just a small nightmare for me compared to this

Late 90's Application Support Guy here in early on the Monday moring to greet the 200 seat Call Centre that was implementing...

Hi There

You need to install ADO.Net 2 onto your SQL 2000 Box

Back in the 80's I worked for a bank & everyone on the Forex desk wanted a nice 21" monitor (They'd seen one of the directors with one). So I also...

Hi There

This might sound silly, but when I had this problem it was because the version of winzip that was installed had not been registered with a valid key.

Try logging...

Welcome to the magical world that is SQL Server

As A Newbie you have managed to master the DB Engine and SSIS in a very short time to come up with...

Nice info to know. Fell foul of the conversion rules with SP4 when trying to use a variable devalred as Decimal(16,0) against a Primary key column defined as Decimal(12,0).

It managed...

I know that the technology for lojacking exists as it's already in use in some high performance cars.

However a problem that happend to a friend of mine might show the...

Or why not have 1 Job that checks the location where the files are produced. If there is anything in there then run the DTS from the Server. Simply Schedule...

Hi All

Let me share a little piece of information with you on some work that I did in the mid 80's. It was using the DEC Alpha Equipment with a special...

Much better way is to use integrated security. You just need a /E on the end then

Very good way to do things

However, don't forget to include a mechanism for easy switch between DEV, UAT and Production file systems & servers