August 29, 2011 at 1:12 pm
This is more regarding creating an SSIS package. While I create an SSIS pkg, I am using the sql command
RESTORE DATABASE db
FROM DISK = '\\'
WITH REPLACE
I get an error that output contains no columns. Could you advice?
Also I am using .bak file to transfer from one server to another. Do I need flat file connection or OLE db connection is good?
August 29, 2011 at 2:04 pm
tracmonali (8/29/2011)
This is more regarding creating an SSIS package. While I create an SSIS pkg, I am using the sql commandRESTORE DATABASE db
FROM DISK = '\\'
WITH REPLACE
I get an error that output contains no columns. Could you advice?
Also I am using .bak file to transfer from one server to another. Do I need flat file connection or OLE db connection is good?
You'll want to create an OLEDB connection to the master (or tempdb) on that server to initiate your connection to, because you'll lose it during the restoration process.
Now, I assume you're using an EXECUTE T-SQL control in the control flow. If not, please advise to your approach, because that error usually comes from the data-flow, not the control-flow.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 30, 2011 at 10:17 am
It sounds like you have the resultset property of the execute sql task to something other than None and it should be none. Unless you aren't using an Execute SQL Task.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply