Hello
I am trying to load data from xml source to sql server destination, but the task executes with no data loaded to destination. i really appreciate any guidance in working and troubleshooting xml sources.
Regards
Harris

Hi First I run execute SQL Task
SELECT TOP(10) [Message],opportunity_Id
FROM SBP
FOR XML PATH ('GS_Opportunity'), ROOT('GSOpportunities')
That will make 10 different file into single file then i have assigned this output to variable and it will output as XML
Now I put Data flow task ,in it I put XML task and in source i have put XML Data From Variable
and I select XSD file location,now XML task is showing me different source table and i have selected appropriate destination table but when i run this package it will not transform data from source to destination,Can you suggest me what is the problem i
try to put data viewer it is not transforming any data while insted of if i select direct file location instead of variable it is running good

I need to create a script in SSIS which creates a data source that connects to an Access database.
The Access database file name needs to be set as a variable as it will change from month to month.
I have no idea what I am doing can anybody give me some tips? Mr Shaw

If you have an excel spreadsheet that displays a number .02 (because it is formated) but internally it is stored as .2654329 and you want to load .2654329 how can you do that in the SSIS package? When we load the spreadsheet it is loading .02.
Is there some kind of option in the SSIS package to tell the package to load the internal number?lcerni

Hi,
I've created a SSIS package, which reads my XML file using XML Source, using SCD(Slowly Changing Dimension) to identify whether to do an Insert/Update and everything's fine so far. But there are chances that my xml file will have new tags added apart from
what are already there. So In that case, i'm not able to figure out whether to alter the table to add new column or something like that.
Need your suggestion.
Thanks in advance
Vijay

I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008. I tried to follow instructions from articles on incremental data load in SSIS using MD5 hashes but I failed to make connection in Lookup transformation
editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is bigint. i tried to add data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup
component it failed.

We have a moderately complex SSIS package that uses a script task to dynamically create a Transfer SQL Server Object task, which then moves data and schema of a varying definition
from source to destination.The SSIS package was written in BIDS 2005.The source system is still SQL 2005 (with latest updates) and the destination system is now 2008r2 (with latest updates).When the package run, we get the following error when we try to execute the dynamically created transfer task: Description: Execution failed with the following error: "Version90 database compatibility level is not supported.".sp_dbcmptlevel for the source and destination databases returns "The current compatibility level is 90.".Master on the target system is predictably at level 100.

Hi I am new to SSIS and had a basic question. I have around 30+ tables in a db that needs to be migrated to a newer schema in the DB. The data flow task seems to be ideally suited for my requirement. My question is do I need to create 30+ different data
flow tasks for this which will get executed one after the other or is there a better way to migrate large number of tables. Also how are referential constraints taken care of during such migration. Thanks and Regards, Ganesh Ranganathan
Ganesh Ranganathan
[Please mark the post as answer if it answers your question]blog.ganeshzone.net

Using a data flow task I am trying to load data from a table in sybase server to sql server. There are approx 10000 rows in the sybase table, however for some reason which I
am not able to find out, at random certain no of rows are getting inserted. e.g. in one run 800 rows then 200 rows etc.

actually we are planning to move data from GreenPLum data base to SqlServer 2005 data base using SSIS as ETL tool. What type of connection manager can we use. Is to good to use OLEDB connection manager or ODBC connection manager.

When I'm trying to load the data from SQL Server into DB2 database. It's trowing an below error. Can anyone help me what would be the possible resaon and workaround for this. ANy help would be much much appreciated.

The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.