DTS/SSIS in SQL express

Question

DTS/SSIS in SQL express

Animal Magic

SSChampion

Points: 13964
More actions
August 23, 2007 at 4:12 am

#178233

I currently have a customer who uses MSDE and has around 50 DTS packages importing data from a third party app into a SQL DB for reporting. The DTS packages are called by a VB app which is scheduled using windows scheduler.
The database is up to the 2gb limit and needs to be upgraded, and due to cost they obviously want to go to sql express 2005, which I know doesn't support DTS/SSIS without the add on components, but even then that's just for ad hoc imports.
Does anyone know if you can still store the DTS packages as structured files and call them in an application against a sql express DB?
Thanks in advance
John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jim sparks Grasshopper Points: 19 More actions · Answer 1

I noticed this message has gotten a lot of views and no replies and thought I'd take a look.

While I can not answer your question about the DTS packages, I can tell you that I use the DTS wizard from SQL Server 2000 to move data into SQL Server 2005 Express databases without problems. I've used it to bring in data from text files and I've used it to copy data from one database to another. I have not tried creating and using any DTS packages or using any previously generated DTS packages against a SQL Server 2005 Express database.

I'm running Vista on my workstation and I believe all I had to do was put the dtswiz.exe file somewhere handy and create a shortcut to it to run it. The first time I ran it it complained about a missing DLL file. The DLL file was in the same place I found the dtswiz.exe file, so I copied it to the folder specified in the DLL error message and from that point on I was able to use the DTS Wizard with Express.

Don't know if this helps but I thought I'd throw it out there since you haven't gotten any replies. Good luck.

jsparks

Animal Magic SSChampion Points: 13964 More actions · Answer 2

Hi Jim,

Thanks for the reply. I have tried running a one off import using the old 2000 exe without issue, but i was wondering if there is a way so automate this process as Express doesnt have an agent, or any ability to schedule packages.

Mai Nguyen-460836 SSC-Addicted Points: 481 More actions · Answer 3

I dowload SQLServer2005_DTS.msi in order to export SQL Express to Access Database. The job fail on me many times is there another way to do it via ADO?