SQL - SSIS - I try to create a Dat

Posted on 2012-09-03
Last Modified: 2012-09-05
When I try to create a data source from OLE DB Data Source Editor,  I get the following error.  See Capture1.   This error only occurs when data access mode set to 'SQL Command'.  If the access mode is set to 'Table or View', I can get the data. See Capture3
Can anyone tell me what i might did wrong. Capture 2 should the connection manager setting.

TITLE: Microsoft Visual Studio

The component reported the following warnings:

Error at Empty CRMentities database [OLE DB Source [1]]: No column information was returned by the SQL command.

Choose OK if you want to continue with the operation.
Choose Cancel if you want to stop the operation.


Question by:tommym121
    LVL 19

    Assisted Solution

    Hi  tommym121,
    Could you show your query?
    LVL 21

    Accepted Solution

    Hi Tommy,

    Need some information to get to understand the problem better

    1-You have not provided any screen shots
    2-what's your source vendor? MSSQL, sybase or which database vendor?
    3-what's your query? is it a SP or temp tables?


    Author Closing Comment

    Thanks for your help.  I find the problem.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    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

    14 Experts available now in Live!

    Get 1:1 Help Now