Empty XML To SSIS Import

Sep 4, 2007

I am trying to take the national weather service XML snaphot and import into a SQL 2005 DB

http://www.weather.gov/data/current_obs/KHOT.xml

in theory this looks like it should work, but I get no data every time it runs

here is a sample of myXML source

<?xml version="1.0" encoding="ISO-8859-1"?>

<current_observation version="1.0"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.weather.gov/data/current_obs/current_observation.xsd">
<credit>NOAA's National Weather Service</credit>
<credit_URL>http://weather.gov/</credit_URL>
<image>
<url>http://weather.gov/images/xml_logo.gif</url>
<title>NOAA's National Weather Service</title>
<link>http://weather.gov</link>
</image>
<suggested_pickup>15 minutes after the hour</suggested_pickup>
<suggested_pickup_period>60</suggested_pickup_period>
<location>Hot Springs, Memorial Field Airport, AR</location>
<station_id>KHOT</station_id>
<latitude>34.480</latitude>
<longitude>-93.100</longitude>
<observation_time>Last Updated on Sep 4, 12:53 pm CDT</observation_time>
<observation_time_rfc822>Tue, 4 Sep 2007 12:53:00 -0500 CDT</observation_time_rfc822>
<weather>Overcast</weather>
<temperature_string>81 F (27 C)</temperature_string>
<temp_f>81</temp_f>
<temp_c>27</temp_c>
<relative_humidity>74</relative_humidity>
<wind_string>From the South at 5 MPH</wind_string>
<wind_dir>South</wind_dir>
<wind_degrees>180</wind_degrees>
<wind_mph>4.6</wind_mph>
<wind_gust_mph>NA</wind_gust_mph>
<pressure_string>30.04&quot; (1016.6 mb)</pressure_string>
<pressure_mb>1016.6</pressure_mb>
<pressure_in>30.04</pressure_in>
<dewpoint_string>72 F (22 C)</dewpoint_string>
<dewpoint_f>72</dewpoint_f>
<dewpoint_c>22</dewpoint_c>
<heat_index_string>85 F (29 C)</heat_index_string>
<heat_index_f>85</heat_index_f>
<heat_index_c>29</heat_index_c>
<windchill_string>NA</windchill_string>
<windchill_f>NA</windchill_f>
<windchill_c>NA</windchill_c>
<visibility_mi>10.00</visibility_mi>
<icon_url_base>http://weather.gov/weather/images/fcicons/</icon_url_base>
<icon_url_name>ovc.jpg</icon_url_name>
<two_day_history_url>http://www.weather.gov/data/obhistory/KHOT.html</two_day_history_url>
<ob_url>http://www.nws.noaa.gov/data/METAR/KHOT.1.txt</ob_url>
<disclaimer_url>http://weather.gov/disclaimer.html</disclaimer_url>
<copyright_url>http://weather.gov/disclaimer.html</copyright_url>
<privacy_policy_url>http://weather.gov/notice.html</privacy_policy_url>
</current_observation>






View 14 Replies


ADVERTISEMENT

Cannot Import Excel Source File With Empty Last Column

Oct 23, 2007

Hi All,

I have a particular issue that has been causing me some problems for a while. I have an SSIS package that imports an excel file into my database, and then performs various data manipulation that I won't go into. The problem I am having is at the import end. The excel source file I am working on is provided to me by my client. It is a fixed format and doesn't change, it contains a header row and there are 32 headings. The trouble I am having is that quite often, the last column is empty, i.e. it contains no data. The header is still there, but theres no data underneath. When I try to import this file using my SSIS package it fails, and complains about needing to remove the metadata for this final column from the External Columns list (VS_NEEDSNEWMETADATA). When I try to preview this file in the properties of the Excel Data Source, the last column does not exist. It's as if it's determining that as there is no data in that final column, that it's unnecessary and not part of the data set, even though it has a header.

Now I've done a bit of research, and found cases that a sort of like mine, I know that the excel file has the first 8 records sampled to determine the data format. This problem suggested to use the IMEX=1 extension in the connection string, which didn't help. I also discovered that when using flat files, if you have odd numbers of columns in your comma seperated list there can be problems. But neither of these issues seem to match the issue I'm facing.

Has ANYONE had a similar problem to me, and can anyone offer any kind of assistance regarding what I need to do to import an excel file that may or may not have data in the final column?

Thanks in advance,

Paul

View 1 Replies View Related

Default To NULL Instead Of Blank/empty String During Flat File Import

Aug 15, 2006

Hi,

In SSIS flat file import using fastload, I'm trying to import data into SQL 2005 previously created tables.

The table may contain column that are NULLable BUT there is NO DEFAULT for them.

If the incoming data from flat files contains nothing either between the delimeters, how can I have a NULL value inserted in the column instead of blank/empty string?

I didn't find an easy flag unless I'm doing something wrong. I know of at least two ways to do it the hard way:

1- set the DEFAULT(NULL) for EVERY column that needs this behaviour

2-set up some Derived Column option in the package to return NULL if the value is missing.

Both of the above are time consuming since I'm dealing with many tables. Is there a quick option to default the value to NULL WHEN there is NO data ELSE insert the data itself? So the same behavior that I have right now except that I want NULL in place of empty string/blank in the varchar(x) columns.



Thanks

Anatole

View 9 Replies View Related

Integration Services :: SSIS ToolBar Empty

Jun 8, 2015

I have installed VS community edition 2013 on a widows 7 PC. When I try to create a ssis package the ssis tool bar comes up empty.It just says "loading" on the panel .

View 2 Replies View Related

Prevent SSIS From Creating An Empty Flat File

Oct 18, 2007

I created a SSIS to export to a flat file (from a SQL command : a stored proc).
I don't wan't my SSIS to create an empty file if there is no data.

How can I achieve this ?


Thanks,

Vince

View 5 Replies View Related

SSIS Converting To Date Empty Fields (no Values)

Jan 8, 2008



Hi, how do I convert dates with SSIS, when I receive dates I have no problem, with empty fields I have to go through a transformation as:


trim(field_name) == "" ? "999999" : substring....... (derive transform)

after this I have to update each field holding '999999' to NULL. (using sql task)

Is there an easier way to doing this?

Thanks

View 1 Replies View Related

Integration Services :: How And Using Which SSIS Component To Change Empty String Value To 0

Oct 4, 2015

I have my SSIS package that reads elements from a Sharepoint list to a SQL table. The data type of my source is string and the destination is integer. The source column can sometimes be an empty string "" (not a required column)

Which expression to use and "where" or "what" SSIS component can I add this expression to? Like I know that I can use the "Conditional Split" to filter the data so for my expression which component can I use?

View 2 Replies View Related

SSIS: Excel Import: SSIS Not Reading Dates

Apr 26, 2008

Hi. I need to import excel file in database. i first need to do an unpivot task. the column names are dates and SSIS seems to be unable to pick up the column name as it is replaced by F2 F3 F4etc Can you advise of a solution. thanks ken

View 1 Replies View Related

SQL Server 2012 :: SSIS - Stop DataFlow Task If Result Set Is Empty?

Oct 7, 2014

I am trying to create a SSIS package that will create a csv of a dataset for daily events in the database. However there will be days that there was no activity and thus an empty dataset. The package still runs fine but I want to stop the package if the dataset is empty.

FLOW:

DATA FLOW task: get daily data and put in CSV file

FTP TASK: upload the file to FTP server

MAIL/Copy file task: Move the file and then send a confirmation mail on task completion status.

Pretty simple and it all works great, I do have a few complexities in there. What I would like to add and I am at a loss is at the beginning, if the OLE DB Task resultset is empty then move to Mail Task otherwise process normally. I have tried conditional split, derived columns, the only thing I haven't tried in Script task and am not sure about that yet.

View 4 Replies View Related

Integration Services :: Handling Empty Text File Load Into Table Through SSIS Data Flow?

Jun 16, 2015

We have created SSIS package to load a text file into a table. Source system shares 10 text files and recently they stopped generating data for one of the text file (comping empty), after few months they will start generating the data for the empty file batch processing. 

The Issue here is Data Flow task is getting failed while loading empty text file into table. How to handle this empty file load issue in SSIS package.

View 3 Replies View Related

SSIS Import

Feb 10, 2007

In MS Excel, the ability exists to run a "web query." This functionis accessed via the data menu's import external data option. The webquery wizard accepts a URL address, and then is able to import thedata from that address into an excel worksheet.What I would like to do is use SSIS to import data from the same website. In other words, I now use Excel's web query functionality toimport data from a website with a url of xyz.asp. I save the excelworkbook, and then run a DTS package to import the data into SQLServer. I would like to entirely bypass Excel, instead of using it asan intermediary to bring data from the asp site into SQL Server.However, I can't figure out how to set up the connection from SQLServer. I am using SQL Server 2005, SSIS. Is there a way to haveSSIS open the asp website, extract the data and import it into a SQLServer table?For the record, this is not XML data.Thanks.

View 1 Replies View Related

SSIS Import

Nov 15, 2007

I am trying to import either .csv or excel files using the SSIS import/export tool in Visual Studio and/or managment studio. the data does import in but I am loosing some data in the files, most often date fields.

View 1 Replies View Related

SSIS And E-mail Import

Jun 15, 2007

Hi all,

I need to import data into my SQL Server 2005 from an E-mail datasource. It means that when a mail is send to a particular address I must retrieve the mail content or the attached file (in XML) and then I must import these data in my SQL Server 2005.

I am new in SSIS and I don't know if I can perform the import task with SSIS (with a POP3 or IMAP connector) or only with SQL Server 2005 (stored procedures) or can I manage it with C# .Net.

Thanks for your help.

Regards,

Michelle

View 1 Replies View Related

Ssis - Import-export

Feb 4, 2008

An excel spreadsheet has to be open on Machine B on the network to pull data from a third party tool.
I have to refresh several columns in this spreadsheet every minute with new data.
Every time there is a new data into the columns i.e. columns 7 and 10, the spreadsheet pulls data from the third party tool automatically and populates other columns i.e. columns 12-15.
Then I will have to retrieve the new data from the spreadsheet into sql server 2005.

So first I wrote a query to use to populate the spreadsheet each time with the result using Import Wizard.
It gives an error: 0xc0202009
And I am not sure if my approach for this project is correct?

What do you think?
Thanks

View 1 Replies View Related

SSIS To Import XLS Then Export To TXT

Mar 12, 2008

Im trying to create a DTS package to import an Excel spreadsheet in to SQL Server 2005 and them Export to a text file. I have successfully imported the data using the import/export wizard, but I am unsure how to add the step that exports the data into a text file. Any ideas or links to a resource that may help me?

Thanks in advance!

View 6 Replies View Related

Import From Excel Using SSIS

Mar 16, 2008

I am new to SQL Server and am trying to import rows from Excel using SSIS and am getting the following error.

Does anyone have any ideas on how to resolve??

SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x80047076 at Data Flow Task, DTS.Pipeline: The output column "SupplierID" (161) on output "Excel Source Output" (9) and component "Excel Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x80047076 at Data Flow Task, DTS.Pipeline: The output column "SupplierID" (161) on output "Excel Source Output" (9) and component "Excel Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, OLE DB Destination [583]: The final commit for the data insertion has started.
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [583]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'SupplierID', table 'Northwind.dbo.Suppliers'; column does not allow nulls. INSERT fails.".
Information: 0x402090E0 at Data Flow Task, OLE DB Destination [583]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (583) 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.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (583)" wrote 1 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.

View 1 Replies View Related

USING SSIS For Scheduled Import

Sep 27, 2007

Hi msdn forum members,

I need to import data from another server using Express edition every minute.
So I ran the import wizard, and I saved the packaged on the hard drive.
Then when I try to make a new job and new schedule for scheduling, I can't seem to find SQL server integration service option for the Type.

does anybody have any idea why I can't see SSIS there or had the same problem??
Or is there another way of importing data every minuite other than this?

BTW my server is 2005 standard edition.

Thanks in advance,

Mike Kim

View 10 Replies View Related

SSIS Import Package

Aug 31, 2006

I created a package using the import utility and have it opened in Business Intelligence Development Studio. Can someone explain to me how I can run this import from here?


Thanks


Scott

View 1 Replies View Related

SSIS Import DB2 Using IBM OLE DB For DB2 Driver

Oct 30, 2007



I'm getting an error message (see below ) using the SSIS Import and Export Wizard to read in IBM DB2 databases on a XP 64 machine. I'm trying to import the DB2 (8.2.8) tables from IBM/AIX to SQL Server 2005. I have the IBM Client V8 with Fixpak 14 installed on the computer.

Using IBM OLE DB Provider for DB2 ( testing connection is fine ) for Data Source
Using Microsoft OLE DB Provider for SQL Server for Destination to SQL 2005 database (also tried SQL native Client )

During the next screen "Copy data from one or more tables or views" I get the following error and no tables show up.

CLI0102E Invalid Conversion. SQLSTATE=07006

Additional Information
CLI0102E Invalid Conversion. SQLSTATE=07006 ( IBM OLE DB Provider for DB2)

I've checked on BLOBs and CLOBs in the tables on the DB2 side and none of the tables I have access to have them (but there are tables with BLOBs and CLOBs in them). I haven't checked on decimal conversion but I've seen DB2 Decimal (30,15) columns in some tables.

If someone could tell me the steps and tables that the Wizard uses to build the table list from, I'll go into DB2 Command Center and run a few queries.

I've also tried the MS OLE DB for DB2 Provider but I get an error message on the authentication method not being supported.

Thanks

View 4 Replies View Related

SSIS Excel Import

Jul 20, 2006

In SQL Server 2000 DTS there is an Extended Connection properties
window that you can set the IMEX property for importing Excel
spreadsheets into a SQL Server table. Does anyone know where this is
in SQL Server 2005 SSIS?


Thanks,

View 5 Replies View Related

Ssis Import And Export

Feb 4, 2008

An excel spreadsheet has to be open on Machine B on the network to pull data from a third party tool.
I have to refresh several columns in this spreadsheet every minute with new data.
Every time there is a new data into the columns i.e. columns 7 and 10, the spreadsheet pulls data from the third party tool automatically and populates other columns i.e. columns 12-15.
Then I will have to retrieve the new data from the spreadsheet into sql server 2005.
So first I wrote a query to use to populate the spreadsheet each time with the result using Import Wizard.
It gives an error: 0xc0202009
And I am not sure if my approach for this project is correct?
What do you think?
Thanks

View 2 Replies View Related

SSIS Excel Import

Feb 18, 2007

Getting started.


Hello All

First time setting up A SSIS

Trying to import a excel that creates a new table called lockbox.

Does not import any records from Columns-Contract Id, Owner ID,
that have a null value.

Then in the Site Id -that is a number value- change to a text value
and update it to it text value.

for example: Site Id Column
2 = Ell
3 = CSI
12 = Ell2

Can someone get me started in the right direction?

Thanks for your time and help

JK

View 1 Replies View Related

SSIS Import/Export Wizard

Aug 7, 2007

I have Sql Server 2005 Developer Edition and Sql Server Management Studio.I'm trying to import data but there are no options available under "Projects" in SSMS.Do I need to download an update or anything to use this functionality?
Thanks

View 2 Replies View Related

SSIS: ETL Import Data Error

Dec 20, 2006

have tried to import data from a big (257Mb, I has about 1.000.000) flat file into a table, inside SSIS. The process doesn’t work correctly. It stops in the same register (about 179.000). I have reviewed the process and have opened the file making it shorter (about 150.000 lines, including the line that before seems to break the process), and it works. Making the file longer it breaks the process again.



The error showed by the program:



Error: 0xC02020A1 at Data Flow Task, Flat File Source [2820]: Data conversion failed. The data conversion for column "debe" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

Error: 0xC0209029 at Data Flow Task, Flat File Source [2820]: The "output column "debe" (4066)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "debe" (4066)" specifies failure on error. An error occurred on the specified object of the specified component.

Error: 0xC0202092 at Data Flow Task, Flat File Source [2820]: An error occurred while processing file "Z:PROYECTOS ITSoluciones de negocioProyectosSANDOProyecto 5. CodificaciónETLcapun00108.unl" on data row 36804.

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source" (2820) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.



Anybody knows what could be happening?

Any help would be very appreciated



Thanks



PD: I mean that it´s not a date format problem (I have reviewed some post talking about it)

View 2 Replies View Related

SSIS Flat File Import Help

Aug 28, 2007

I am trying to import a flat file into SQL Server 2005 using SSIS. I have never used it before and I am getting confused by the error I am receiving.

I have a link to a flat file, that gets sent through a Derived Column flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Then the string MM/DD/YYYY is converted to a date in a Data Conversion flow. And finally the data is put into a SQL Server table (currently with no rows).

The problem I am having is with a text field with the email address in it. The error I am getting is:

[Import Allstate Auto Club [1]] Error: Data conversion failed. The data conversion for column "email_source" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

The problem is I can't see where in the flow the problem is. The field length is 20 wherever I look and the codepage is 1252 wherever I look. Does anyone have an insight? Keep in mind, I have never used SSIS before and I consider myself an amateur with SQL Server. It could easily be a data type conflict or something easy. Any help will be appreciated.

View 1 Replies View Related

SSIS And Import/export Wizards

Jan 11, 2007

Guys,

I am new to SQL Server 2005. I have installed Developer edition. I want to transfer data through DTS which is now SSIS - Sql Server Integration Service I believe.

One question though how do I access SSIS, I am doing normal imports and exports using the wizards. Is there any other interface to access the SSIS??

Please let me know

Thanks

View 3 Replies View Related

Import Multiple .DBF Files W/SSIS - OLE DB

Dec 7, 2006

Hi all,New to SQL Server - trying to create an SSIS package that will look forand import a series of Visual Foxpro tables (.DBFs) when they appear ina folder.The tables are/can be all different fields, field widths, etc. Withquite a bit of overlap though.The end result should be table "ABC.DBF" is pulled into SQL Server astable "ABC"Using: SQL Server 2005 Enterprise, SSIS, *latest* version of VFPOLEDBdownloaded from MSI have set up a package and tested it with several different tables andit works great - but I have to redo the data source and destinationeach time...I need to get this to be a somewhat automated process, pulling in all..DBFs no matter what they contain.Can I do this with SSIS alone (and variable substitution) or do I needto write a bunch of code...Thanks very much for your time and thoughts...

View 1 Replies View Related

SSIS - Import Flat File

Apr 17, 2006

I have a fixed width flat file I'm trying to insert into an SQL 2005 table using SSIS -- it's a recurring task. One of the columns in the flat file has to go to a column of type Numeric. No matter what I try : a data conversion, defining the field as DT_NUMERIC in the connection,... I always get "The conversion returned status value 2 and status text :The value could not be converted because of a potential loss of data". It is driving me bonkers, up to the point that I find myself wishing for the 'good old' DTS days of SQL 2000. And I dread to think what will happen when I try to port some serious, much more complex DTS packages on my SQL 2000 to SQL 2005.

The data in question represents longitudes and latitudes so quite often there is a leading white space in the data : ex. : " 95.15". Surely that cannot be the cause ?

I've spent hours doing the RTFM-thing and searching the newsgroups, fora...you name it. Apart from ending up running in circles in the MS documentation, the only thing I've really learned so far is that I'm aparently not the only one driven to dispair by the new SSIS thing.

I can think of a number of ways to hack my way around this thing, but that's not the kind of 'progress' I had in mind when I started the move to SQL 2005.

Intelligent suggestions would be most welcome.

View 1 Replies View Related

SSIS Import Error 0xC0202009

Nov 27, 2007



HI I'm still in the middle of this 2000 to 2005 64 bit migration!! I have managed to create an oledb connection to my informix db. Within the data flow I wanted to create a simple data pump from my infdormix db to S2K5 db.

Now in the OLEDB source I have done a select froma table to which I can view. I also set the always use default code page to true.


On the error box I get


[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error 1 Validation error. Reason code: OLE DB Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Cerptransfer.dtsx 0 0


Also when I try to execute it I get


Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Reason code [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Live@jvert07_se.service" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error at Reason code [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Error at Reason code [DTS.Pipeline]: One or more component failed validation.
Error at Reason code: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)


Can anyone help as i'm dead in the water now.

many Thanks

robert

View 11 Replies View Related

SSiS Vs Import Wizard: What's Wrong?!?!?

Sep 28, 2007



Hello everybody,

I'd like to import a big table (about 13 millions rows) from oracle to sql server 2005.

2 ways are possible: SiSS and Import Wizard.

I'd prefere to use SSiS, but I'm unable to pass data from oracle because, for some strange reason, debugging the package it hangs on the origin block (painting it red) altought another identical package wit another table works perfectly (and that's another strange question...). Also, SiSS forces me to create a convert block to cast from unicode to ansi


Using Import Wizard in sql2005 instead, the package works perfectly and, importing it in SiSS, it also don't contains the convert block...


what's the reason of all that?

thanks in advance

View 6 Replies View Related

SSIS Import Option Missing

Jan 31, 2008

I want to start the SSIS wizard to import data from a flat file, but I right click the DB > select Task and the Import and Export options are not there. Is there something I have to enable before the options show up

Thanks

View 3 Replies View Related

Export And Import Of SSIS Packages

Mar 26, 2007

Hello All,

Is there a way to completely export an SSIS package (the package, the configuration and the SQL Agent settings).

And a way to import it into another computer running SSIS.

If yes, then can this be done by means of a script?

regards,
Abhishek.

View 1 Replies View Related

Import Multiple Xml Files In Ssis

Jan 28, 2008



I am building a ssis package that imports multiple xml files containing data into the tables using one xsd file. I am using xml source task for this. I can only import one file as the primary key constraint gets violated.

I have four tables with four primary keys. The xml file does not have the primary key column data. So every time these columns get populated as 1, 2, 3, 4.

I am preety new to xml, so was wondering if anyone can help?
Why doesn't the xml file have primary key column data?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved