INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Check for existing database then use else create new database

Check for existing database then use else create new database

(OP)
Very green to SSIS so please bear with me. Trying to set up a package to automate ETL. All of the processes happen on one server. Using VS 2008.
1) check to see if database exists - if it does, load file(s) into a specific table in that database.
2) if the database does not exist, have some type of entry point to allow me to create a new database using a script that restores a template database to the newly added database.

List the current databases, if there pick it, else add new name of database.

Thanks for your help and time, it is greatly appreciated!

RE: Check for existing database then use else create new database

Hi, not sure exactly about SSIS, however, this may be of some help to get started.

To get a list of databases in SQL use:

CODE --> T-SQL

SELECT
	name
FROM sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb') 

The NOT IN isn't really needed but it just excludes the system databases.

There are two ways to write error-free programs; only the third one works.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close