Tagged Questions
0
votes
2answers
36 views
'skip rows' in a flat file source does not work as advertised
In SSIS(2012 specifically) there is an option in the Flat File Datasource to skip a number of lines at the beginning of a file. The preview appears correctly. However, when trying to execute the data ...
1
vote
0answers
36 views
Accessing environment variables at design time in SSDT?
I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me.
The result that I am trying to achieve is that the user context's temp folder(stored ...
4
votes
1answer
72 views
Convert SQL Server 2012 SSIS package to 2008
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to ...
1
vote
2answers
122 views
Will SSIS 2012 work with SQL Server 2008R2 (not integrated)
Our company has SQL Server 2008R2 and plans to upgrade to 2012 in late 2013 or early 2014. I would like to use SSIS 2012 now as we do have the software.
We have a company policy where we cannot run ...
1
vote
1answer
62 views
SQL Server 2012 catalog.executions to sysjobhistory - any way to join them?
I have exhausted my resources and can't find a foolproof way to join the ssisdb.catalog tables to the jobs that run them. Trying to write some custom sprocs to monitor my execution times and rows ...
3
votes
2answers
194 views
Relating ExecutionInstanceGUID to the SSISDB
The 2012 release of SQL Server Integration Services, SSIS, has delivered an SSISDB catalog which tracks the operations of packages (among other things). The default package execution for solutions ...
4
votes
2answers
102 views
In SSIS 2012, what is the purpose of flagging a package as an “Entry Point” package
In the Visual Studio designer you can right click on a SSIS package and designate it as an "Entry Point" package"
Doing a search I found this page on MSDN which states:
The value of 1 signifies ...
3
votes
1answer
62 views
Integration Services Catalogs - Version Description
In Integration Services Catalogs I can see what versions of a package/project are available and if necessary revert to an older version. On this dialog I see a field "description" however I found no ...
0
votes
1answer
109 views
SSIS SQL Server 2012 cluster Availibility Group
We have a three server cluster using AlwaysOn technology, and have created an Availability Group for the SSISDB catalog.
How would you change the code to only execute on the primary server?
2
votes
0answers
78 views
How to use a foreach loop with project deployment model
I have a SSIS project that is configured to project deployment model, within this I have two connections one for a flat file and one for a sql db. Both connections are in project mode. Now I want to ...
6
votes
1answer
532 views
Timeout expired error while using copy database wizard
Microsoft made me believe that SQL Server 2012 Copy Database Wizard is the most optimal way of copying a SQL Server 2000 database to SQL Server 2012. After struggling a few hours, I was able to get ...
2
votes
1answer
2k views
Access denied when trying to run an agent job
Can someone please point me in the right direction. I keep getting the below error message when I try to run a job that executes a package I created and saved on the SQL Server.
12/03/2012 ...
1
vote
1answer
143 views
Connect to SQL Server 2012 Database from 2008 Agent Job containing 2008 SSIS Package
I'm planning the rollout of SQL Server 2012. My client has a number of SQL Server Integration Services (SSIS) packages currently deployed to SSIS 2008 and consumed by SQL Server Agent Jobs defined on ...
2
votes
2answers
147 views
Advice on how to approach data cleaning & importing
I am importing and cleaning data from a datasource that have records like this:
The data needs sorting and rearranging based on the Event Type.
The destination schema would be something like ...
1
vote
0answers
145 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
4
votes
2answers
177 views
SSRS: how to handle unavailability of service when datawarehouse is being rebuilt
We use SSIS to build datawarehouse (full Microsoft environment). This is legacy SSIS package that starts by truncating all tables in datawarehouse, run nightly.
During this time, we restrict access ...
