Solved

Convert SSIS Package into VBA

Posted on 2007-04-05
4
726 Views
Last Modified: 2013-12-25
I would like to use vba to upload flat files into a SQL Server 2005 database.  SQL Server 2000 allowed you to record a DTS upload package in VBA but SQL Server 2005 does not offer this option.  Instead it allows you to record a SSIS upload package.  

Is there any way to create the vba code for uploading into SQL Server 2005 or convert the recorded SSIS package into VBA?

Thanks
0
Comment
Question by:Linda_Zhang
4 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 18863863
I have never seen a SSIS package, but coding VBA to upload a file to SQL Server is fairly straight forward, and depends on the structure of the file.   How does the file look and how does the table look?
0
 
LVL 15

Accepted Solution

by:
CSLARSEN earned 500 total points
ID: 19282620
A colleague of mine made this work:
Use a command shell to run the SSIS package
Enter "dtexecui.exe" in start->Run

cheers
cslarsen
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now