I have column in the destination table that does not allow nulls.  I
have a lookup table to grab an item's ID.  If the item doesn't exist, I
simply want to skip this row.  Sounds simple, but I've been pulling my
hair out for the past two days on it.  No matter what I do, I cannot

Hey i am planning to use the BULK INSERT to copy the data into my Server. The
data is being written to the file by external application.
But i want the data that is being written should be deleted after the
insert. Can BULK INSERT statement support such option to be specified. ...

I have a xml data file, I want to use DTS to convert xml data to MSQL table.
Is that possible to design?

Hi ppl! I want to get the type of task from a task object.  
In the package I have an Execute Package Task and an ActiveX script task.
In the ActiveX script task the code looks like this:
   For Each oTask in oPkg.Tasks

I have designed a DTS package and have enabled SQL Server logging in
the properties of the DTS package. Since this is writing to the msdb,
does it just keep on writing? How do I specify how long I want to keep
the logging information around in the msdb?

Executive summary:
How do you create a DTS connection in vb.net 2003 code to an Excel spread
sheet?
Background:

I know how to loop through one set, but wasn't sure if there was an easy way to
loop over two variables, something like:
Get list of servers
Get next server from Server recordset --a

Here's a weird one, but I'd be more than grateful if anyone could help.
I've been given the task of recreating a DTS, the only problem is when
I try to view the contents of the DTS, I see nothing. When I try to
create a new DTS, I get an empty window with no icons on the left (when

I am currently using the LoadFromStorageFile method i.e.
myPkg.LoadFromStorageFile DTSPkgFile, "", , ,
DTSGlobalVariables("UploadSubPackageName").Value which works great, however I
would rather use the LoadFromStorageFile method but get various security

I'm trying to view a database using Enterprise Manager and am getting the
following error when I try to view the list of tables, stored procs etc:
Error 229: SELECT permission denied on object 'sysobjects', database
'tours180805', owner 'dbo'.

Our data center recently backed my SQL server to install new hard drives.  
Upon restore I noticed that all my DTS's and Job's are missing.  When I
brought this to the Datacenters attention , they stated that all data was
successfully restored from tape.

I want to use ini files to store server details, but feel that storing
server username and password in ini file is not secure.
Any suggestions?
regards,

I have a DTS package which concatenates 3 columns of a table and exports
this final column into a flat file.  I need to add a final register to
this flat file (the number of registers on the file which is the last
last row of the column) how can I do this?

I would like to be able to right click on a DTS package in windows explorer
and have it open in DTS Designer?
I'm using Sql Server 2000
is this even possible?

How do I set the datasouce to dynamically change to the server it resides on?