SQL - SSIS - I try to create a Dat

Posted on 2012-09-03
Medium Priority
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

Rimvis earned 750 total points
ID: 38362755
Hi  tommym121,
Could you show your query?
LVL 21

Accepted Solution

Jason Yousef, MS earned 750 total points
ID: 38363722
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

ID: 38370046
Thanks for your help.  I find the problem.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

864 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