I am trying to log the performance counters for my SSIS Pipeline, for things like Buffer memory, Buffers in use, Buffers spooled, etc. I created a new log and added all those counters to it. Things are beeing logged, at every 15 seconds to the file, but all it's beeing logged are values of 0 - no matter the time of execution or the elem...
Hi, I want to convert a database from access to SQL Server using SSIS. I cannot convert the date/time columns of the access db. SSIS says something like: conversion between DT_Date and DT_DBTIMESTAMP is not supported. (Its translated from my German version, might be different in English version). In Access I have Date/Time column, in ...
Hi , I have a ssis 2005 project. I have to add a zipping task.ie, i have to zip a text file. But i have to follow DB standards of the ORG. strictly. 1) No 3rd party software in the DB server.Not even resourec kit tools 2) No exe's in the DB server. so i cant use(windows resource kit tools,7-zip, and a execute process task to invoke...
I have a Data Flow Task and am connecting to a database via an OLE DB Source component to extract data. This data feeds into a Conditional Split component to separate the data based on a simple expression. After the evaluation of this expression, the data will end up in either of two locations: LocationA or LocationB. Alright, I have ...
I am working on a new Datawarehouse trying to import a number of different format files from a number of different providers. The filenames may be the same each month, such as MonthlyReturns.xls/.csv, or a pattern, such as NorthWestSalesData20100101.csv). We can't ask the providers to change their naming convention. Do we have to crea...
I have a folder where files are going to be dropped for importing into my data warehouse. \\server\share\loading_area I have the following (inherited) code that uses xp_cmdshell shivers to call out to the command shell to run the DIR command and insert the resulting filenames into a table in SQL Server. I would like to 'go native' an...
Hi I am Migrating SSIS package from SQL Server 2005 to SQL Server 2008. The package ran successfully in sql 2005 using provider "SQLNCLI.1". In sql 2008 I have changed the provider to "SQLNCLI10.1" it gave below error: Error:SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested provider "SQLNCLI.1" is not registered. But I am us...
Hi All, Trying to edit an SSIS package, when I go to the advanced editor on the update database package I can only see on the component properties page three properties. ID, Name and Description. when my colleague opens this up he can see 20+ options including the SQL option I am needing to be able to edit. Is this an issue with my SQ...
I pretty new SQL Server Integration Server (SSIS) user. Is SSIS able to query data from text files located in another Windows Server? I mean that when SSIS is installed on Windwos Server A, is SSIS able to query data from e.g. one folder containing text files in Windows Server B (under same domain)? I have used only SAP BO Data Integrato...
Hi , I wanted to know if there is any system variable which is can use to access package execution start and end times. My requirement is that i need to store this in 2 relevant fields in a table in the database. Thank you. Abhi ...
We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml. What is the best way to do this using SSIS? Is this a good approach? Or should we just try and write the reports directly of...
Our care management system uses a web service to import data. I've successfully executed one of its methods using soapUI, and now I want to replicate this with an SSIS 2008 web service task, but I'm running into a problem. I've created the "HTTP Connection Manager" successfully, and specified the location of the "WSDLFile", but when I go...
I have set up a View as the source for a Sql Server Package Configuration that has the same name and columns as the default table. It works in design-time but the package fails to load the configurations claiming the view is an Invalid Object at run-time. This seems like it should work because the view appears in the drop-down in the ed...
Hi All, I have a maintenance plan that looks like this... Client 1 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next Client Client 2 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next Client Client N ... Import Data and Process Data are calling jobs and Post Process...
In the script of the script components the Output buffer is not being detected as an existing component. I am trying to use the following piece of code Output0Buffer.AddRow(); within the public override void Input0_ProcessInputRow(Input0Buffer Row) method. I know it should be available within this method because at the moment I am ...
Hi, I have a SSIS package used the protection level as "DontSaveSensitive" So initially i have saved the oledb connection manager password as in a XML config file.And this worked fine for me. Now for business requiremnt i have stored the configuration in sql server. Including password. Initially it worked fine.But suddenly connection...
Hello I have a SQL server 2008 and I would change the name of the backup file. I use an SSIS package to perform my backups. The file's name looks like [DATABASE_NAME]_backup_YYYY_MM_DD_XXXXXX_XXXXXX This is automatically generated by SqlServer, and I want to remove the "_". How I can modify this ? Thank you in advance, Andy. ...
I have a simple SSIS Project. In the control flow I have three steps: Step 1: Select Data from Db1.Table1 Step 2: Create Table2 in Db2 Step 3: Copy Data in Db1.Table1 to Db2.Table2 If I "Execute Task" one by one in order, it executes fine...but if I try running the entire project I receive the following error: Error a...
Is it possible to abort the processing of a row in the ProcessInputRow method? I'm doing some data validations with the incoming CSV data in this function. I'm setting the row values in a sub. If an error occurs i'll catch it in the ProcessInputRow and start writing the data into a staging table for a later approval. Everthing works fine...
I'm having a strange problem with SSIS. I'm exporting some data from a database into a flat file. It comes out all fine - except that rather than displaying the data like this: ID FirstName LastName Age It comes out like this: ID FirstName LastName Age ID1 FirstName1 LastName1 Age1 Now, its not repeating the same da...