Best to put a ExecuteSQL task before the datapump to load the data into a staging table, then use the datapump to select from that table.

Thanks

Phill Carter

--------------------

Colt 45 - the...

DTS will asume the security context of the process that is actually executing the package. Maybe you could try a CmdExec using 'Run As'.

Thanks

Phill Carter

--------------------

Colt 45 - the original point...

What is the structure of the data like? How are the two tables related?

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Try this article

http://support.microsoft.com/default.aspx?scid=kb;en-us;315968

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Check the following article

http://support.microsoft.com/default.aspx?scid=kb;en-us;285006

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Is the following article applicable?

http://support.microsoft.com/default.aspx?scid=kb;en-us;274330

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Can you run up another server without SP2 and trying opening the package?

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Get the drivers for SQLBase from here ( you will have to register )

http://www.guptaworldwide.com/register/default.asp?ProductGroupID=7&ProductGroup=SQLBase+Driver+Pack&HasPlatforms=0&Type=ProductGroup&ID=7

They support OLE/DB, so away you go ...

Thanks

Phill Carter

--------------------

Colt 45 - the original point...

Here's a link for you,

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=2&tabid=3

Thanks

Phill Carter

--------------------

Colt 45 - the original point and click interface

Simplest way is to put a password on the package. There are two levels 'Owner' and 'User'. An Owner password allows the package to be edited and run, the user...

Never had any success with GetExecutionErrorInfo. Ended up building my own script to extract the info from the DTS logging tables. You can have a look at my script here,

http://www.sqlservercentral.com/scripts/contributions/556.asp

Thanks

Phill...

Antares, are you thinking of SQLCheck from NetIQ?

http://www.netiq.com/sqlcheck/

It's not as full featured as SpotLight but it has the same sort of graphical interface. It's OK for highlighting problems, but doesn't...

The user id that the Task Scheduler ( WINAT )uses would need to be granted access to the SQL Server. Usually, the Task Sceduler uses a Local System account so...

Writing a stored procedure with an IF statement will provide you with the most optimal execution in terms of time and resources.

Using Dynamic SQL will lead to things like stored...

Probably the best method would be to import the file into a staging table with only one field. Then run some SQL to spilt the record up into your destination...