?
Solved

Convert SSIS Package into VBA

Posted on 2007-04-05
4
Medium Priority
?
756 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 2000 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

801 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