October 7, 2013 at 1:43 pm
Hello Everyone
I have had some SSIS packages that I converted to SQL 2012 using the SQL tools, what was once BIDS. I would like to edit one, but none of the tools are active. Has anyone else experienced this?
Thank you in advance for your assistance, comments and suggestions.
October 7, 2013 at 3:16 pm
AndrewSQLDBA (10/7/2013)
Hello EveryoneI have had some SSIS packages that I converted to SQL 2012 using the SQL tools, what was once BIDS. I would like to edit one, but none of the tools are active. Has anyone else experienced this?
Thank you in advance for your assistance, comments and suggestions.
What do you mean with none of the tools are active?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2013 at 3:48 pm
I mean that all the tools in the Toolbox and the SSIS Toolbox are InActive. They cannot be selected.
Andrew SQLDBA
October 8, 2013 at 1:26 am
The regular toolbox is normal, the SSIS toolbox however not.
You are using the SSDT that comes with the SQL Server installation right?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2013 at 11:16 am
AndrewSQLDBA (10/7/2013)
I mean that all the tools in the Toolbox and the SSIS Toolbox are InActive. They cannot be selected.Andrew SQLDBA
Are they grayed out? What do you mean they cannot be selected?
MCSE SQL Server 2012\2014\2016
October 8, 2013 at 2:28 pm
Yes, "inActive" means they are "greyed out" I can select them, but I cannot do anything. They will not drop onto the work area.
I have figured it out though. It was rather odd when you open a package in SSDT that was created in an older version of BIDS. That seems to be what was causing the issue in this case.
Andrew SQLDBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply