Solved

Convert SSIS Package into VBA

Posted on 2007-04-05
4
751 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

717 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