Am I right in saying you've got two parallel transform data tasks: One is working, the other is not?

What kind of connections are...

Hi,

Are you using a linked server to connect to the dbf file and are looking to create and index on one or all of the tables? Or have I completely...

You could use an ActiveX script to assign the filename to a Global Variable and then either continue the script to set the DataSource or use a Dynamic Properties Task after...

Okay, I think I've got it....

You'll need the ActiveX task to open the workbook that'll run the Workbook_Open Macro (you may need to change...

Try Something like this as an ActiveX task

Function Main()

dim xl_app

dim xl_Spreadsheet

set xl_app = CREATEOBJECT("Excel.Application")

set xl_Spreadsheet = xl_app.Workbooks.Open ("C:\book1.xls")

xl_app.run "Thisworkbook.RunMe" ' Macro Name to be run

xl_Spreadsheet.Save

xl_Spreadsheet.Close

xl_app.quit...

Thanks for letting me know. Always pains me when the answer is so simple.

Although my Hindi/Indonesian (haven't decided which it is yet, probably the former) is rusty, I believe that your reply involves originating from the loins of a horse and that I am...

Try this ActiveX script in a DTS package:

Function Main()

 Dim objSvrHTTP

 Dim fso

 Dim f

 Set objSvrHTTP = CreateObject("Msxml2.ServerXMLHTTP.4.0")

 objSvrHTTP.open "GET", "http://www.globalindices.standardandpoors.com/data/wdpmi_bus.csv", false

 objSvrHTTP.send

 msgbox objSvrHTTP.responseText

 Set fso = CreateObject("Scripting.FileSystemObject")

 Set f = fso.CreateTextFile("c:\download.csv", True)

 f.write objSvrHTTP.responseText

 Set...

Can you post the DDL of the tables involved please?

Using a transaction could work butmay be dependant on the SQL being executed. Would

BEGIN TRAN trial

    sp_executesql @Sqlstring

ROLLBACK TRAN trial

work? Or is this as dangerous as the little niggling voice...

Can you give some more information as to how the CSV file is manually downloaded from the website?

There could be a number of issues here, causes of this error can include naming, aliasing, or join errors. I'll list what I can think of:

1. Check the owner of...

If you notice the WHERE clause in the statement this will stop any rows with NULL values in the serv_lev column being inserted into tblMatchNSI.

You can have a second query...

Dave, when you say "keep the on-screen layout intact", do you mean how the DTS package looks in DTS designer? If so, continue to use the BCP method...

If it's a question asked of you then surely you should be coming up with the answer and not attempting to pass off someone else's work as your own???