SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services

how to assign query results tovariable(int32) in execute SQL task

samita_sawant — Tue, 08 Apr 2008 23:34:13 GMT

hello, i m working on a SSIS package in which i m returning query results & trying to assign it to a variable with int32 datatype.database is oracle & m using the connection microsoft oledb connection for oracle.in sqltask my query isSelect max(record) from target here i hv taken resultset as single row type & assigning values to rowname 0 to var1 max(record) is of numeric type.but when i run the task its giving the error that [Execute SQL Task] Error: An error occurred while assigning a value to variable "va1": "Unsupported data type on result set binding 0.". please help me m sruggling alot for the issue.

Running stored procedure from Execute SQL task not working as expected

Jarom Richardson — Wed, 23 May 2012 10:02:14 GMT

I am executing a stored procedure from an Execute SQL Task that doesn't appear to be doing anything. The procedure performs a few numeric calculations and executes an update statement if a condition is true. Basically when I test it, it should be executing the update statement and it never does seem to meet the condition when I run it through SSIS. I am using verison 2005.I am using the OLE DB connection. I am passing in three parameters from variables (listed with their data types):LUKey - StringOPrc - DoublePrcDiff - Double In the input parameter screen I have the following:LUKey - Input - VARCHAR - 0OPrc - Input - DOUBLE - 1PrcDiff - Output - DOUBLE - 2Here is the structure and syntax of the procedure. Maybe someone can notice something that I do not see.CREATE PROCEDURE [dbo].[usp_Procedure1] (@LUKey varchar(50), @OPrc money, @PrcDiff money OUTPUT)ASBEGIN SET NOCOUNT ON;DECLARE @SumPrc moneySET @SumPrc = (SELECT SUM(Price)FROM Table1WHERE Category2 = @LUKey)SET @PrcDiff = @OPrc - @SumPrcIF NOT @PrcDiff = 0BEGINUPDATE Table2SET Price = (Price + @PrcDiff), Category4 = @PrcDiffWHERE Category2 = @LUKeyENDENDWhen I put breakpoints on the PreExecute and PostExecute I see the variable PrcDiff start at a value of {0} and then on PostExecute it shows a value of {2.35944361387577E-315} which kind of makes me think that the could be a datatype issue somewhere here. No errors occur, but the update statement is not being executed when it should based on the condition.Any ideas?

ForLoop to check any row is present in the source table

Jim1234 — Wed, 23 May 2012 03:48:25 GMT

Hi,I'm using a ExecuteSQL Task within a ForLoop. I need the ForLoop to keep on executing till any row is returned by the ExecuteSQL task. The query in ExecuteSQL task is Select Count(*) from Table1.For this I have created a UserVariable @RowCount. In ExecuteSQL the Resultset is set to @RowCount.In the ForLoop, EvalExpression is @Rowcount>0 and InitExpression, AssignExpressoin are not set. So that ForLoop is success when some rows are present in the table1 and ForLoop will keep on executing when no row is present in the table1. Now, even there is no row in the table, ForLoop is successful. I'm not understanding the behavior and how to resolve same.Please help or suggest some pointers.ThanksRegardsJim

Db_Mtc_2005.Mtc_And_Full_Backups shows faill message but the back up is there in the backDrive, how can i stop this?

Kassan — Wed, 23 May 2012 06:42:15 GMT

Date 05/23/12 2:00:00 AMLog Job History (Db_Mtc_2005.Mtc_And_Full_Backups)Step ID 1Server PSQLJob Name Db_Mtc_2005.Mtc_And_Full_BackupsStep Name Mtc_And_Full_BackupsDuration 00:58:13Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: Wmd\srv-sql. ...rsion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:01 AM Error: 2012-05-23 02:57:53.99 Code: 0x00000000 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Description: BACKUP DATABASE successfully processed 23243 pages in 7.592 seconds (25.079 MB/sec). End Error Error: 2012-05-23 02:57:54.06 Code: 0x00000000 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Description: The backup set on file 1 is valid. End Error Error: 2012-05-23 02:57:55.20 Code: 0xC002F210 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Execute SQL Task Description: Executing the query "set nocount on declare @instance_name varchar(128) , @db_exclude_list varchar(512) , @datestamp varchar(20) , @retain_bkp_set_days int , @bkp_root_path ... The package execution fa... The step failed.

Excel Source via Ole Mixes Columns F1, F2 etc.

Christian.Schaffner — Wed, 23 May 2012 10:29:33 GMT

Hi,I have got a problem with my Excel import. I get a file without column headers. I retrieve the content by a select statement Like :Select F1, F2, F3......If I copy the content of the Excel file into another workbook by pasting it into A1 and then try to use the new file as source SSIS mixes up the columns.F1 is then Column B instead of Column A.I had the same Problem with another sheet. First Column A was empty data starts at Column B. Without copy paste and starting with column B I use the following Select Statement:Select F2, F3, F4......Worked OK on DEV.Then I moved the SSIS package from DEV to UAT, but there the content of F2 was now Column C instead of B.It is like Column A is ignored and F1 starts in Column B.I have got no clue how to handle this. For UAT I had to change my query to Select F1, F2, F3...... to get it working.Anyone an idea how to handle this or what might be the reason?RegardsChris

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154

Jeremy Larcombe — Fri, 20 Jan 2006 10:56:00 GMT

I'm getting this message when executing the SSISDeploymentManifest file on SQL Server 2005 (32 bit) running on Windows Server 2003 SP1 Standard Edition (64 bit). The package was created on another SQL Server 2005 machine, where it executes OK.

I can run the dtsx file OK, only the manifest file has this problem.

Has anyone come across this one before?

Thanks

===================================

Unexpected error occurred. (Package Installation Wizard)

===================================

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)

------------------------------Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application..ctor() at Microsoft.SqlServer.Dts.Deployment.PackageInstallationWizardForm..ctor() at Microsoft.SqlServer.Dts.Deployment.PackageInstaller.Main(String[] args)

===================================

Load Excel text to SQL table via SSIS

khorkh888 — Tue, 15 May 2012 20:56:03 GMT

Hey All Expertises,I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:[b]Date KPI Plant Remarks[/b]01-04 A 1 U3 not is down01-04 B 1 02-04 A 2 L3 is down due to 1) no material 2) no schedule 3) waiting for vendorAs you can see, the Remarks column can have "enter" value. How to load all this into SQL table with same display as in Excel?Help needed please. Thanks.

Import data from Visual Fox-Pro Table

Thozamile.Javu — Fri, 13 Feb 2009 06:39:12 GMT

Hi,Has anyone ever came accross this error? See below message. I'm using MS SQL Server 2005 and trying to import data from a Visual Fox-Pro table to a SQL table. Manually and via SSIS.TITLE: Microsoft Visual Studio------------------------------The component reported the following warnings:Warning at {AE44B2B1-E8EC-46B4-A56A-98CCB11816D8} [Source - dirlnk [1]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.Choose OK if you want to continue with the operation.Choose Cancel if you want to stop the operation.------------------------------BUTTONS:OKCancel------------------------------

How to insert/update/delete into destination table

pradeep.mohan — Fri, 11 May 2012 05:23:49 GMT

Hi Gurus,I am totally new in ssis package,in my package i want to insert,update and delete into destination table.Eg: If source table happening any DML Operation that should be need to replicate into destination table also once the package is run.What to do?How to achieve the target. Help me on this...:-) Thanks in Advance.

SSIS - importing flat files - how to dynamically unpivot the data

inampudianil — Tue, 22 May 2012 03:49:01 GMT

Hi Team,i received a flat file with the structure like this name and last couple of dates with quantityeg: Name | 22/05/2012 | 21/05/2012===================================== product1 | 30 |40 product2 | 0 |30 product3 | 25 |24 Now my destination table schema is Name,date,Qtyeg: Name | Date | qty============================ Product1 |22/05/2012 |30 Product1 |21/05/2012 |40 Product2 |22/05/2012 |0 Product2 |21/05/2012 |30 Product3 |22/05/2012 |25 Product3 |22/05/2012 |24Now,how can i achive this in SSIS...plzz help?ThnxAnil

Failover in SSIS

Jim1234 — Sat, 24 Mar 2012 08:16:35 GMT

Hi,My SSIS package needs to pull data from a table (say table1 in Database1 in Server1). When data is not available in table 1 it should pull data from another table(say table2 in Database2 in Server2).Please suggest how to approach/implement this.This tables are oracle tables.ThanksRegardsJim

Excel file connection nit getting closed in Foreach ADO.NET Schema Rowset Enumerator

ram11sql — Mon, 21 May 2012 09:30:50 GMT

Hi I am using "Foreach ADO.NET Schema Rowset Enumerator" to get sheet names, but excel file connection is not getting closed after the loop is completed. How to close the file once exection of reach "ADO.NET Schema Rowset Enumerator" is completed.Thanks

SSIS Config File Issue

sqlquest2575 — Mon, 21 May 2012 08:59:34 GMT

Hello Friends,I have created my package in Dev env and now i have to run that package into production. So i figured out that i need to create a config file and make necessary changes to connection string and move both config file and ssis.dtsx pacage to production server but when i run this package on production i get an error message . ... i am loading data from a file to sql server and i also moved the file,DTSX pacage and as well as the config file but i still get the error DTS_E_Cannot acuire connection from connection manager. The acquire connection method to callthe connection manager "C:\test\test.mdb" failed with the error code 0XCO209302

SSIS to export XML.

Tim Heap — Mon, 03 Jul 2006 07:45:00 GMT

Please help this is driving me bananasDoes anyone know why there is no faciilty with SSIS to export text as XML, only as a file source ?I have a requirement to export to XML from within SQL2005 and I can't believe MS hasn't got the facility to do it.Thanks.

The package failed to load due to error 0xC0010014 "One or more error occurred.

- Win. — Wed, 17 Jun 2009 23:58:23 GMT

Dear Experts,Could please help me in resolving the below error.... Trying to execute a .dtsx package, but facing the below error.......TITLE: SSIS Execution Properties------------------------------The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.------------------------------ADDITIONAL INFORMATION:The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.------------------------------BUTTONS:OK------------------------------_____________________________________________________________________________________Error: 2009-06-18 11:22:05.32 Code: 0xC001700A Source: Description: The version number in the package is not valid. The version number cannot be greater than current version number.End ErrorError: 2009-06-18 11:22:05.33 Code: 0xC0016020 Source: Description: Package migration from version 3 to version 2 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".End ErrorError: 2009-06-18 11:22:05.33 Code: 0xC0010018 Source: Description: Error loading value "3" from node "DTS:Property".End ErrorCould not load package "D:\Execution Log Sample Reports\RSExecutionLog_Update.dtsx" because of error 0xC0010014.Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.Source:

Inserting data in DB2 through SSIS

rashid nizam — Wed, 18 Feb 2009 03:31:56 GMT

Dear ALL, I am stuck into a weird problem.Actually i am trying to insert data in DB2 OS/390 7.1.1 through OLE DB Destination in SSIS.The provider i am using, while creating connection manager is "IBM OLE DB Provider for DB2" from drop down list.But when i try to insert data from a source any (no matter oracle or SQL server) it gives me the error [OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E53.[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination 1" (834) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.Connection is poperly establish, once can test connection and it gives Sucess.User have proper rights, you can select the same data when u create DB2 as a OLE DB source. And another strange thing one you insert data through a Execute sql Task and give insert statment .....it inserts the data..................but the same data with OLE DB Destination, gives me the error mentioned above.we have 2 millions rows to inserts in DB2, ervey now n then.....so can any body suggest me how could i fix this problem...........dont wanna use script component.....in that case i might have to insert row by row....which is really a performance hit.IS this a known issue........any fix....way around.Your quick response is highly appreciated.ThanksReport post as abusive

Sending XML result set to MSMQ queue

xanthos — Tue, 29 Jul 2008 02:30:04 GMT

Hi all,I need to send an XML-file to a remote private MSMQ queue using SSIS.The MSMQ-task doesn't send to remote private queues. Has anyone any idea how to do this?

send (conditional) email task

dave 92282 — Fri, 11 May 2012 09:49:47 GMT

So I have my package which basically pulls csv files from an ftp site to a local folder and then my task loops through the files and imports them into a table, once this has finished I then delete all files locally and from the ftp site.The package runs every hour, and I would like to send an e-mail upon completion of the job, but I only want the email to go out if the package actually imported any data, I don’t want e-mails being sent at the end of the job if there were no files processed. Any ideas on how I can achieve this please.

How to validate text file data using bulk insert

SAG2011 — Thu, 17 May 2012 01:00:33 GMT

Hi,I want to import data from text file.format of file is as follows:date,id,unit_number,Quantity05/17/2012,1,117,10005/16/2012,2,118,100I am using bulk insert do it.like thisBULKINSERT vw_bulk_insert_testFROM '\\server\c$\csvtext.txt'--\\server\SQLEXPRESS\csvtest.txt'WITH(FIRSTROW=2,check_CONSTRAINTS,FIELDTERMINATOR = '~',ROWTERMINATOR = '')GOBut before insert I want to validate values of each column.Like if second row will have values of all fields except unit_number then it should throw an error that unit_number value is missing.And it should not insert ant data after that.Please guide me on the same.Thanks in advance.

SSIS driving me nuts... again!

Eric Mamet — Sat, 12 May 2012 17:20:28 GMT

I found the problem and fixed it but... I'd like to understand! :crazy:I have an "OLE DB Command task" that fires a SQL Server stored procedure with ~20 named parameters.EXEC MyProc @MyArg1 = ?, @MyArg2 = ?, @MyArg3 = ?...What I don't understand is how does SSIS generates the "Available Destination Columns" based on these parameters?For some reason SSIS got it's nickers in a twist and the order of the "destination columns" displayed did not match the order of the parameters in my statement... I may have modified my statement but... "so what?"It looks like OLE DB relies on this order as Profiler showed me SSIS was firing the proc with the params based on their order rather than name.Is it just me... or is it really that messy?ThanksEric

Multiple Data Flows Hanging

Phil Parkin — Sat, 12 May 2012 23:59:28 GMT

SSIS 2008.I have a simple (in concept) package which takes data from 9 flat files and imports to 9 SQL Server tables in a database.It does an INSERT/UPDATE thing, so uses lookups to direct unmatched rows as INSERTs and matched rows are directed into a staging table, for subsequent set-based UPDATE of the base table by running a stored proc. The lookups are not cached, given the large size of base data.The routine has been running fine for a couple of weeks.But yesterday, three of the data flow tasks decided to hang in the middle of processing.Repeated runs of the process showed that (at least according to BIDS) the data flows always hang after processing exactly the same number of rows.The underlying tables are fairly large (190 million rows, 10 million and 53 million).I tried creating an empty table which was a copy of one of the tables and firing into that - this seems to work.I ran a full database index rebuild in case that might have been an issue. No change (I let the routine run all night).If anyone has any ideas about what might be going on or what I could try, I would be appreciative. I am really puzzled as to what might be the problem here.Phil

SSIS centralized encrypted password

tripower — Tue, 15 May 2012 13:16:33 GMT

We have numerous SSIS packages that have Oracle passwords embedded in the connection objects of the SSIS package which is a nightmare for maintenance. Is there any way to keep a centralized password, encrypted , so that the connection objects can access this at run time?

Oracle Developer backspace key not working

yurinapage — Tue, 15 May 2012 06:39:00 GMT

I have an issue: I have no shortcuts set up in SQL Developer but my backspace key stopped working all of a sudden. I use the load preset and it reset. The keys will work but then in a couple of days it stops working again. Any suggestions as to why this is happening?

A sort gone bad?

herladygeekedness — Fri, 11 May 2012 13:50:54 GMT

Created a small package with one data flow that has multiple sources that are merge joined together through the flow. We are a hosted business so my sources contain different servers, different clients and I use sorts to get server/client in line before joining (we have a custom component that "makes the rounds" of whatever servers I enable for that run to return the data).The package worked perfectly until it didn't, which was in teh course of one day. What is now happening is that the sort after "the main records" runs to a certain point and stops. no error. package just hangs. And will stay that way all night (had to see...)It will be the same record count thru the sort each time. If it weren't so reliably reproduceable, I might suspect bad data.Fearing corruption, I first replaced the sort component and then completely remade the package. It is still occurring.If I pull only one or two small clients, it works as it should.I was wondering if it's possible that other sources getting their data and thru their sorts and ready to input to MJ before the "main records" get thru their sort could be the issue? I would love a sequence container in the data flow to test that, but, not an option. I would otherwise have to dump to temp tables to split into mult data flows which we don't want to do but maybe will haev to? Any ideas welcome!

Data viewer - can I get it to jump to the row where the task failed?

caspersql — Mon, 14 May 2012 09:17:53 GMT

Hello all, I have setup a SSIS task for importing a csv flat file into an OLE DB destination. There are about 64,000 rows in the csv file. After about 51,800, my task is failing. In my data viewer, I'd like to see the record that failed (ideally) or if that's not possible, the one before the one that failed. Unfortunately, when I click the 'play' button in the data viewer, only 100 rows at a time are displayed. It would take 518 presses of the play button to get to the row where the task is faililng.Without pressing 'play' 518 times, is there a way I can get the data viewer to display the rows as they are processed, and then stop when the task fails so that I can see the most recently processed row? Any suggestions would be much appreciated.

Ftp connection to download few specific files

marttali — Fri, 11 May 2012 07:14:15 GMT

Hi,ssis noob here :) But willing to learn.I have visual studio 2008 if this matters. And the question is- how to i download from ftp site few specific files (wildcards can't be used i guess, file names like aaa, aaab, bbb, bbbx). There are 100s of files there..i could create a csv file storing those filenames i need to download. What next ?Or a better way to start ?

SSIS - importing flat files - how to specify date format

thepotplants — Mon, 16 Jun 2008 20:55:56 GMT

Hi I'm new to SSIS and have been climbing the steep side of the learning curve...I have built a file loader which imports a few dozen .csv files each day into a MSSQL database table, and generally it works ok. My only problem remaining is how SSIS interprets dates in the .csv file. My data is mm-dd-yyyy, and SSIS is interpreting it as dd-mm-yyyyHow do I enforce the interpretation to be mm-dd-yyyy? ( I assume this is set at the point you read the data.. is that correct?)Any help would be greatly appreciated.

An error occurred while skipping data rows.

sanjaykumar557 — Wed, 09 May 2012 10:30:57 GMT

The column data for column "Column" overflowed the disk I/O buffer.However, This column shows unicode and also I am not using this column for store in destination. Please help on this ASAP.Thanks,Sanjay Kumar

Multiple extracts using single DTS

ramrajan — Fri, 04 May 2012 04:26:29 GMT

i have stored procedure which returns two results.CREATE PROC usp_sampleAS select * from employeesselect * from DepartmentNow i have to export the two results sets data to two csv files with names employees.csv and department.csv.How i can achieve this fuctionality using DTS package in sqlserver 2000.Please help me ................

need to export multiple text file in same package

surma.sql — Tue, 08 May 2012 13:33:49 GMT

Hello FriendsI have a task, in that i have 7 different scripts. and i need to Export all result for that sql script in to Text files in same SSIS Package.So is it possible in same package so i need to run once and after execution it creates 7 different text files.If Possible then please reply meThanks

can ssis package take data from more table

ahmed_elbarbary.2010 — Mon, 07 May 2012 04:26:28 GMT

Hi guys i have one question are ssis package in sql server 2005 can take data from more tables in database to another that i know it take data from tables or view and if possible how

Import Data from Multiple Excel Sheets using SSIS

purushoth.Chennai — Fri, 16 Jan 2009 01:43:08 GMT

Hi friends,Can anyone help me out how to extract data from multiple excel sheets (same excel doc having multiple sheets) using SSIS 2005Thanks,Purushoth

SSIS from MYSQL to SQL 2005

Kathy Massey — Wed, 28 Mar 2012 12:47:19 GMT

We have a database that we pull records out of daily from MYSQL to SQL. Some fields populated in MYSQL show as blank in SQL.Example - Dialednumber (Unicode string [DT_WSTR]) goes to SQL - Dialednumber nvachar(97)other fields come through just fine.Any ideas?

Problems setting connectionstring of FTP task.

Eric Lieberman — Thu, 08 Jun 2006 15:03:00 GMT

I am having trouble setting the connection string for an FTP task. Let me explain....

I have a SQL table that contains all my source servers ( ip,port,user,pwd,folders etc ) . I created a ExecuteSQL task that loads this into a recordset. I then use a FOREACH ADO Enumerator to loop thru the table. So far so good. I am trying to set the connection string of a FTP Connection, using an expression, using the variables I maped in the FOREACH task.

I set the connectionstring on the FTP Connection Manager to "@[User::username] + ":" + @[User::password] + "@" + @[User::ipaddress] + ":21"" but it looks like the FTP task is always trying to connect to ":@:21" . Obviously it is not using my variables which are not assigned until inside the FOREACH task. I can see the variables with the correct values if I put in a break point. My guess is that it is only trying to set the FTP connection manager once when the package starts and not once for each loop in the FOREACH task. Any ideas ?

SSIS Package Logging to System32 directory

Mythilis — Sun, 02 Mar 2008 23:09:30 GMT

Hi All,Overview:We are using SQL 2005 with SSIS and have created a set of packages which load data from txt. files into our DW staging tables and then from our staging tables into our star schemas. The packages used variables that are stored in xml config files. The parent package calls and executes each package in sequences and the child packages inherit variables from the parent.Issue:One of the variables set in the config file specifies a directory to write the log files into and SSIS logging is set to use SSIS Log provider for Text files and with a File_log connection using Create file and an expression using the log directory variable for each package. When I execute the packages as a SQL Agent job, it creates logfiles before picking up the variable which specifies the desired location for these logfiles. The location where the logs are written to is the WINDOWS\system32 directory. If I run the job under an account with sufficient permissions, a set of log files are created within the WINDOWS\system32 directory as well as the intended log file directory and the job executes successfully. However log files building up in the WINDOWS\system32 directory and using an account with those permissions is not a long term option. Executing the package straight from the SQL Server- by right-clicking on the package name in Management studio- does not write this second set of log files and also runs successfully, however this job is required to be scheduled each night hence this is also not an option.If I hardcode the logfile directory variable into the packages the unwanted 2nd logfiles are not created- however I do not want to hardcode my packages, I would like the execution to use the specified variable.Has anyone come across this issue and/or has any ideas how to resolve it such as specifying a working folder on the command line?

Parse XML

sarvanjonty — Mon, 07 May 2012 06:24:01 GMT

Hi Everyone. I am facing problem while parsing the below XML.[code="xml"]<site> <status>0</status> <bankAccount uniqueId="23232323" acctType="checking"> <accountName>TESTDATA</accountName> <accountNumber>503-1123xxx</accountNumber> <accountHolder>accountHolder</accountHolder> <balance balType="availableBalance"> <curAmt curCode="USD">54.78</curAmt> </balance> <balance balType="currentBalance"> <curAmt curCode="USD">44.78</curAmt> </balance> <transactionList> <transaction uniqueId="14141414" type="debit" baseType="debit"> <description>CHECK # 998</description> <checkNumber>998</checkNumber> <amount curCode="USD">59.00</amount> <link>link</link> <category>category</category> <transDate localFormat="MM/dd/yy">2005-07-16T00:00:00</transDate> </transaction> <transaction uniqueId="1111111" type="deposit" baseType="credit"> <description>DESC</description> <link>http://www.abc.com</link> <amount curCode="USD">343465.00</amount> <transDate localFormat="yyyy-MM-dd">2005-07-16T00:00:00</transDate> <postDate localFormat="yyyy-MM-dd">2005-07-16T00:00:00</postDate> <checkNumber>DAG-333</checkNumber> <category categoryId="333">other</category> </transaction> </transactionList> </bankAccount>[/code]I tried the following code in Script component.[code="vb"]Public Overrides Sub CreateNewOutputRows() 'Read A/c Details for each node from XML For Each xNode As XmlNode In xDoc.SelectNodes("//bankAccount") BankAccBuffer.AddRow() BankAccBuffer.AccountName = xNode.ChildNodes(0).InnerText BankAccBuffer.AccountNumber = xNode.ChildNodes(1).InnerText BankAccBuffer.AccountHolder = xNode.ChildNodes(2).InnerText BankAccBuffer.AvailableBalance = xNode.ChildNodes(3).InnerText BankAccBuffer.CurrentBalance = xNode.ChildNodes(4).InnerText BankAccBuffer.CurrentBalance = xNode.ChildNodes(5).InnerText Next End Sub[/code]First 5 nodes are fetched perfectly but when it comes to xNode.ChildNodes(5).InnerText the value "CHECK # 998" is not fetched rather it reads the whole rest of the values - "CHECK # 99899859.00linkcategory2005-07-16T00:00:00DESChttp://www.altova.com343465.002005-07-16T00:00:002005-07-16T00:00:00DAG-333other"so I would like to know where i am going wrong or advice me with an alternate to handle this xml file. Thanking you in advance

moving data only from branch to branch by text file

ahmed_elbarbary.2010 — Mon, 07 May 2012 00:54:25 GMT

I have sql server 2005 standard edition sp2 installed and configured in two branches but not in same network. this two branches have two databasesfirst branch database Asecond branch database Bif i want to moving all data exist in all tables from database A to database B daily how can i make thisNotesTwo databases A,B have same structures and schema every thing but differentonly in data.Two branches not connected each other online by vpn or any thing .[b]what i need is practical solution to export all data(not objects) from database A to text file then import these data from this text file to database B are this possible if possible how[/b]please help methanks

Object reference not set to an instance of an object.

sarvanjonty — Sun, 06 May 2012 23:18:03 GMT

I am using a Script component as source and trying to read a XML file. But when I tried using Load() function it throws an error. So for testing purpose i just used LoadXML() and used a message box to display a string. Still i receive the same error. Please help me to resolve this. Kindly see the attachment for the script.

ssis start up error

Radh — Wed, 09 Feb 2011 02:54:16 GMT

HI,, all i was facing problem when i try to start the sql service integration services in services.msc. Actually error is ,,The service did not respond to the start or control request in a timely fashion.Any body suggest me what is the exact reason? how to resolve this one.

Object reference not set to an instance of an object.

sarvanjonty — Sun, 06 May 2012 23:19:51 GMT