February 19, 2014 at 2:40 pm
Hello everyone,
I just want to thank you in advance for all the help that you can give today.
I just started at a new Company, as a junior DBA, the previous person left. Before that person left he created a lot of SSIS packages and turn them into jobs basically to refresh many different tables on the SQL server. The datas are being import from another datasource, which is why the SSIS packages was created so we can bring the datas over to SQL side. Now all the SSIS packages and jobs are working perfectly fine, but whenever I want to create a new SSIS Package for a new job, I always get the same failure as below...
"Error: 0xC0047062 at Data Flow Task, Source - Query [1]: System.OverflowException: Arithmetic operation resulted in an overflow.
at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount)
at System.Data.Odbc.OdbcDataReader.GetRowCount()
at System.Data.Odbc.OdbcDataReader.FirstResult()
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper90 wrapper)
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Source - Query" (1) failed the pre-execute phase and returned error code 0x80131516.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - GLCGLDS" (103)" wrote 0 rows.
Task failed: Data Flow Task
SSIS package "SSIS_GLCGLDS_GL.dtsx" finished: Failure.
The program '[16836] SSIS_GLCGLDS_GL.dtsx: DTS' has exited with code 0 (0x0)."
Below are the exact steps that I do to create the SSIS Package (based on the notes from previous person)
1. right click on SSIS Package and select sql server import and export wizard and click next
2. Select data source as .Net framework Data Provide for ODBC
3. Input Datasource, and driver as: TS ODBC Multi – Tier Driver
4. Choose destination as Microsoft OlE DB Provide for SQL Server
5. Write a basic select statement.
6. Click edit Mappings
7. Here's the important part... I am ABLE to preview the DATA.
8. Click ok next finished
9. Click debug start debugging
10. The preparation SQL task will be green, but the Data Flow Task will failed everytime for me.
If anyone has any suggestion please let me know, b/c I have try every possible ways and out of luck, and I don't want to explain to my boss I don't know how to do it or how the previous person does it without any failures.
TL
February 19, 2014 at 3:00 pm
Your problem is at the top of the stack.
lektri1 (2/19/2014)
"Error: 0xC0047062 at Data Flow Task, Source - Query [1]: System.OverflowException: Arithmetic operation resulted in an overflow.
There's something in the source data (preview isn't the entire data load) that is too large for the field type in the metadata. You need to decipher what that is.
If anyone has any suggestion please let me know, b/c I have try every possible ways and out of luck, and I don't want to explain to my boss I don't know how to do it or how the previous person does it without any failures.
Why not? You already said you got hired on as a Junior. This is when you learn. There's a few billion things I don't know in SQL Server, and I admit that daily. If you can't say you don't know and have to research, you're really going to have a lot of problems down the road.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 19, 2014 at 3:12 pm
Thanks I'll try that...I told my boss that I will do some research on the matter, I just don't want to comeback empty handed
February 19, 2014 at 3:25 pm
lektri1 (2/19/2014)
Thanks I'll try that...I told my boss that I will do some research on the matter, I just don't want to comeback empty handed
Ah, that's a VERY different statement, and one I fully endorse. 🙂
What's the source system, if you can disclose it?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 19, 2014 at 3:33 pm
The source system is a set of tables from a software call Cimpro...not sure if anyone has ever heard of that
Tl
February 19, 2014 at 3:40 pm
lektri1 (2/19/2014)
The source system is a set of tables from a software call Cimpro...not sure if anyone has ever heard of thatTl
Sorry, I should have been more clear. What's the source data RDBMS? Oracle, MySQL, Lotus Notes?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 19, 2014 at 3:47 pm
Honestly I do not know what is the source data
February 20, 2014 at 7:06 am
Today I just realized that all the SSIS packages are failing for me, not just the one I created, even the ones that were working before, the ones that was created by the previous person, I just went to Start Debugging and it would failed at the same exact stage as in my original post.
Anyone with any insight would be much appreciated, thanks.
TL
February 20, 2014 at 7:20 am
can any of the steps in the ssis package be run in ssms? if so you should try doing that to just make sure you know what to expect and account for in your ssis package...also do you know what has changed from before when it was working til now when its not working? maybe that might help you a bit if you can find that out
February 20, 2014 at 7:39 am
The steps are pretty basic...just a select statement from the Datasource and populating into the table on SQL server side. And I am able to run and open the Datasource table from SQL server side using "Linked Server" and with the select statement below
SELECT * FROM OPENQUERY (gl, 'SELECT * FROM GLCGLDS') where gl is the linked server.
I have no idea what might have changed, all the previous SSIS packages was already there when I came on this job and everything is still working, until recently that I have to create a new SSIS packages that is when it's not working for me.
TL
February 20, 2014 at 1:34 pm
Anyone????
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply