DTS Execute from Com Object (Workgroup Version)

Hey Guys,

I have written some code that executes a DTS package from a COM object. It works great on my staging server which is MSSQL 2000 Standard Edition. I just got a new live server which has MSSQL Server 2000 Workgroup Edition. Now I recieve an error message when trying to execute the DTS package from the COM object. Is this perhaps something that is not supported with the Workgroup edition? Is there anyway to varify for sure because as you all know it would cost me a good amount of money to upgrade.

Thanks in advance!

JayStang wrote:

Hey Guys,

I have written some code that executes a DTS package from a COM object. It works great on my staging server which is MSSQL 2000 Standard Edition. I just got a new live server which has MSSQL Server 2000 Workgroup Edition. Now I recieve an error message when trying to execute the DTS package from the COM object. Is this perhaps something that is not supported with the Workgroup edition? Is there anyway to varify for sure because as you all know it would cost me a good amount of money to upgrade.

Thanks in advance!

I recommend you try the DTS newsgroup microsoft.public.sqlserver.dts

DTS and PKs/FKs

Hey guys, i have a db on my home dev server and When I used DTS to upload everything to the prod server, I noticed many FKs did not go thru. Some did, some didn't. I have about 77 tables a few with more than 5 FKs. Is there a reason for this? What's going on? Only thing I can think of, and I don't know much of the DTS internal process, is when the DTS was being performed and a table is created maybe the FK would not pass if the other table was not created? Does DTS create all the tables first, then performs the FKs or what? Any help will be grateful.

Thanks.Nevermind, i just found out that they ARE there. They just didn't show in EM until I opened the PK Table. then it showed in the FK table. Thanks.

dts & mail

hi guys...

how is do for when finished dts ,sending mail by sql server..also i am using sql server 2000...

can i do ?

thanx,,,

Try asking this in the DTS forum: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

This is for SQL Server Integration Services on SQL Server 2005

DTS - Import CSV

Okay guys im having a problem... i've created a DTS package to import a CSV file, but all fields containing integers shoot me an error stating that it can't insert a STRING into an INTEGER column...

Does anybody know how to circumvent this? I've googled it to death and still can't come up with a solution. Maybe i'm asking for the wrong thing... who knows... PLEASE HELP!!!Would it be better if i just imported an xls or mdb or someething?|||Hi,

you might want to open the .csv file in Excel and check if the particular columns that are causing the problem are not of text type.

Cheers,
Ziyi|||every entry in this colum is integer... meaning no characters, just numbers...