Question,

In SQL Server 2005, is it still necessary to create indexes for Foreign Keys? I was under the impression in SQL 2000 and previous that a Foreign Key is...

Enable logging on the Package (preferrably to a sql database). All documentation points to reading the "sysdtslog90" table in the "msdb" database. However, I am not sure because...

Either

1.) just use the old names ex. SysObject, SysColumns, etc

or

2.)

If Object_ID('sys.objects') Is Not Null

EXEC('select * From sys.objects')

Else

EXEC('select * From sysobjects')

Heh, you got me, that would be easier...

This is not supported but you could write a Custom Component which can run your Script files. There are plenty of articles for "Compiling" .NET Code on the fly...

I agree with Ninja. I use the "Split" function when I can like say passing in a list of IDs I want retrieved from the database. However, I...

You could use the afore mentioned method of parsing using a comma-delimited string. However, using OPENXML is better in this case because you can use it to mass insert...

Clifton has a valid point. I too have worked with EDI for over 8 years. EDI (usually ANSI x12) was developed for making transmissions across the "wire" smaller...

Ok, I solved my own problem. Since you will not find a solution anywhere on the internet, here it is. It only took 9 hours of searching the...

Scott, do a search on the articles "Sales Order Workshop". It will give you some good examples in SQL 2005 on how to mass insert data from your Xml...

I have a question (and please excuse me if it's been asked before). If I am using SSL between a WebClient and WebServer, is it possible to intercept the...

I saw somewhere that there is a "File Watcher" SSIS Component. This would help. However, you could also have the Sql Job just kick off an EXE that...

You can't. Google "SSIS Surrogate Keys". You can do something similar by first retrieving the MAX(ID) from the Database Table. Store the MaxID in a variable.

Next, have...

I am having the same issue with a custom component.

Jim, all "code" is done in VB.NET. The object "Dts" is created for you by the code designer and is used in Script Tasks ONLY! Do not use...