Solved

SSIS

Posted on 2011-03-04
1
306 Views
Last Modified: 2012-05-11
  Source: test Connection manager TEST   Description: The connection string format is not valid. It must consist of on
e or more components of the form X=Y, separated by semicolons. This error occurs
 when a connection string with zero components is set on database connection manager.
End Error
0
Comment
Question by:knaren1975
1 Comment
 
LVL 16

Accepted Solution

by:
vdr1620 earned 250 total points
Comment Utility
As it says your connection manager is not defined in the correct format.. click on the connection manager TEST and check the Connection string value in the properties tab.. Post the value, for more help
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

9 Experts available now in Live!

Get 1:1 Help Now