Hi, I want create SSIS package as a DB User. Also I want to store it to SQL Server not in file system. The DB user only have a db_owner privilege on a particular database. What least privileges are required to create SSIS. Already I have assigned the following grant execute on dbo.sp_ssis_checkexists to test grant execute on dbo.sp_...
I have an SSIS Package stored in the MSDB database which works fine when I execute it. It will run under SA account or will use Windows security. I want to schedule this job to run with SQL Agent, but when I do I get a strange error and whatever configuration I try it fails with the following error: Executed as user: SERVER\SYSTEM. on ...
I have etl task that will extract data from Mysql database and load into sqlserver. I created ssis package to perform this job on my local machine. In the source, i used ADO.net with mysql driver. everything works perfectly. but when i move the package file,the dtsx file, to the server which is a 64bit windows 2008 box and execute it, I ...
I would like to use SSIS to create database table flat file exports then import them in to variously distributed SQL Express installs. As you may guess, SSIS is not available in the Express version. When I do the bulk insert, it errors with: Msg 4866, Level 16, State 8, Line 1 The bulk load failed. The column is too long in the data f...
We got a nightly backup/restore managed by another source. And we need to execute an SSIS package right after restore. At the moment, all the processes are executed in a timely fashion by estimating how long every step can take which is very error prone. Question is, how can i check if restore finished and execute the SSIS package? ...
I have a batch file that runs an SSIS job. I have no knowledge of how the SSIS job runs, I took over a project involving it. The batch file uses %ERRORLEVEL% to detect errors that occur within the SSIS job. It must be expanded to report other errors too. How do I set the ERRORLEVEL in SSIS? ...
Im wondering if its possible to make my ssis package work with siteminder. the ssis package will run nightly and connects to a webservice and make a few method calls. but webservice is protected by a siteminder agent. docs say siteminder will only work for environments that support cookies (such as the browser). does anyone know how to s...
Is it faster to use 1 type of provider over the other? We are using SSIS (SQL Server 2005) to pull some data from Oracle and import it into SQL Server. It was my understanding that OLEDB is faster, because the connection is native, and the data isn't being run through any .NET code? Is this correct? ...
I am trying to create an SSIS package that queries data from a table, and calls a stored procedure in another database with each row. In my old DTS package, I was doing this: EXEC myStoredProcedure ?, ?, ? ...and then I mapped the parameters. However, in SSIS, I can't figure out how to make this work. I have a Data Flow task, which...
Could anybody tell me what the current trend for SQL Server Integration Services is? Is it better than other ETL tools available in market like Informatica, Cognos, etc? ...
Group, I have Visual Studio (VS) 2005 and 2008 installed on my local machine. I am creating SSIS packages using BI Studio and the package will build and run fine on my local machine. However, as soon as I move it to the server I get the error: Error SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level insufficient for component......
I have a table in my source DB that is self referencing |BusinessID|...|ParentID| This table is modeled in the DW as |SurrogateID|BusinessID|ParentID| First question is, should the ParentID in the DW reference the surrogate id or the business id. My idea is that it should reference the surrogate id. Then my problem occurs, in my data...
This question is long winded because I have been updating the question over a very long time trying to get SSIS to properly export Excel data. I managed to solve this issue, although not correctly. Aside from someone providing a correct answer, the solution listed in this question is not terrible. The only answer I found was to create...
I would like to pass USER VARIABLES from my package into Script Tranformation Editor. How do I add this into my Row.Reference1 below? Here's the script that I use: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptM...
this code using an OLEDB source will populate the OutputColumnCollection below it, the code using a flatfile source will not populate the OutputColumnCollection. Why not? Microsoft.SqlServer.Dts.Runtime.Application a = new Microsoft.SqlServer.Dts.Runtime.Application(); String SSISPackageFilePath; SSISPackageFile...
Hey, Im having problems moving my SSIS Projects to a new PC. At the moment I have all my Projects in C:\Documents and Settings\myname\My Documents\Visual Studio 2005\Projects But my .dtsx packages are located in a different folder. This folder does not exist on my new pc. So whenever I try open the projects on my new PC It complains i...
i used the import/export wizard in sql server 2005 management studio to export rows from an excel sheet to an sql table and checked the Do not delete rows in destination table option. I saved the export operation as a ssis package, and yes new rows are being appended to existing ones, but now i have a requirement to delete all rows in th...
I am developing an SQL Server Integration Services package. I have been doing some major refactoring to this package, and now the designer is running really slowly. Even moving components around the screen causes the designer to hang for 2-3 minutes. Looking at the task manager Visual Studio is consuming around 80% of the CPU during t...
Hi If webservice returns No value(return type is Array of Event) am getting an error SSIS Package calling websrvice task and output assigning to xmlfile.If the value is there ,No error,only when no value,then package fails. how to handle webservice task when it fails ...
I have two sets of data which I need to join, but there is an added problem because the data quality is not great. The two data sets are Calls (phone calls) and Communications (records created about phone calls). They have ID's called call_id and comm_id respectively. The communication records also have call_ids to perform the join. The...