.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

SSIS Environment Issue

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

SSIS package loads all the rows in DB when I execute it directly from package. But when I execute it through Job or using command prompt it loads some rows and skips some rows in between and finishes with success. I've never experienced such issue before. This has started happening all of a sudden. 2 months back this package was running fine.

Can someone please help me?




View Complete Post


More Related Resource Links

SSIS Lookup Transformation Issue

  
I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore if no change. I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.  example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it  and type_cd (decimal(18,0)) with values(0,1,2,3,4,5) It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer what i found is for all the llokup columns its having nulls (no match found). Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected. Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again  

SSIS Deployment Reads local Environment Variable and not Server

  
Hi All, I have an SSIS package that uses an Environment variable to hold the connection string for the local SSISConfiguration table.  This works properly on my local machine.  However, when I import the package to Integration Services(through SSMS) it reads the environment variable from the local machine and not the server it is deployed to.  If I log on to the server remotely and do the same process it uses the the correct environment varible... (SQL Server 2005) Is there a way to deploy the package to the server and get it to use the correct Env variable without having to log-in to the server and import it?  Let me know if anyone is looking for additional information.   Thanks!

SSIS And Sybase Source OLEDB connectivity issue with code page for character set

  
Hi I am using SSIS 2008 to connect the Sybase Server version 15.0.3 64-bit. The default character set id used by this Sybase server is 4 (i.e. roman8). (http://manuals.sybase.com/onlinebooks/group-charc/chg0300e/charsets/@Generic__BookTextView/1706;pt=266) I had installed Sybase Client for Sybase OLEDB Driver (ASEOLEDB) to integrate this in OLEDB Source Editor. As per guidance from one of the past MSDN forum discussion, I tried setting property of AlwaysUseDefaultCodePage property to "FALSE"  (http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f5af9328-e1fb-48d7-a85d-1d08bb7cf0e5/). However, I am still experiencing error message as follows:- ********************************************************* Error at Package2 [Connection manager "xxxxxx.xxxxxxx"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[00000] [Native Code: 30061] [ASEOLEDB]Could not load code page for requested charset". An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[1ZZ001] [Native Code: 30016] [ASEOLEDB]Internal Error". Error at Data Flow Task 2 [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMC

SSIS Package execution issue

  
HI ALL i am in great need,i am using ssis 2008 i have a package and two task in it..both task have OLEDB source and OLEDB desination when i execute the package whole data get dump from source to destination .but still my package does not show that it has been executed successfully..means package still show yellow color (processing mode)..not showing green color even after dumping whole data BOth package run one after other first dataflow task i have join with second data flow task....(second task start loading data but still fist package that has loaded data is in yellow color)

Compatibility issue between Job and SSIS Pacakge

  
HI All, I have created package in SSIS which process the cube in Incremental mode,but what problem i am facing when i run the package first,its runs successfully but not updated the cube while when i run the package secind time it upload the data in to the cube and this happens regulrly. This happens with processing mode too.  Kindly Suggest what mistake i have commited.   Shraddha  

MOSS Environment VM license issue

  
Hi, We have one VM where all softwares are installed which are required for MOSS development environment. This includes Windows Server 2003 with SP2, MOSS 2007, Visual Studio 2008, SQL Server 2005 etc.   I would like to know is there any license required to install this VM on number of machines. I want to install it on 15 mahcines.

SSIS issue with dynamic excel sheet name

  
Hi Team, I am creating a Excel file dynamically using a script, excute sql and then the dataflow. I am not able to cretae a excel sheet name without an underscore exisitng file: "team data" even though am giving the table name in excute sql task(which is excel sheet name) as "team data" it is creating the name as "team_data" because of which the package is failing? I am able to achieve this with an underscore, as it is a client requirement to generate wihtout an underscore am posting this question. Is this an issue with Sql server 2005? Thanks, Eshwar  

SSIS Issue

  
Hi Guys/Gals I’m trying to schedule a SSIS(SQL Integration Services 2008) package containing a FTP Task that copy files to a remote server. The problems is if I run this package in  Visual Studio is works 100%. When I schedule that exact same package using SQL Server the package run successfully but no files was copied. There is no error message or nothing. Is their a way to track this log   Thanks in advance for any help with this one   RTTAdmin

SSIS Issue

  
Hi Guys/Gals I’m trying to schedule a SSIS(SQL Integration Services 2008) package containing a FTP Task that copy files to a remote server. The problems is if I run this package in  Visual Studio is works 100%. When I schedule that exact same package using SQL Server the package run successfully but no files was copied. There is no error message or nothing. Is their a way to track this log   Thanks in advance for any help with this one   RTTAdmin

Custom SSIS task inteface building issue

  

Hi all,

I'm tying to use the class foundation that SSIS provides to build interfaces like those of built in tasks

I tried to follow this tutorial

http://blogs.msdn.com/b/mattm/archive/2008/07/18/creating-a-custom-task-with-a-default-ui.aspx

I added a Display text property to my task in order to display it when the task is fired, every thing goes well

except three  issues

1. The display value is not persisted( when I change it from the GUI inteface. It is only persisted if it is updated from the BIDS properties grid)

2. The buttons OK, Cancel, Help are not displayed at the buttom of the interface such in the rest of built in tasks, should I add them programmatically and  if it is the case how  do I to persist properties values when user clicks OK.

3. Some cells in the properties grid shows a combo box like those configuring  connection managers. For example one can expand the combo box and selects <New Connection...>  

Or when one property grid cell get the focus then ellipses button appears when he/she clicks then the OpenDialogResult opens up

Or if one selects some properties grid cells then the properties grid changes by

Compatibility issue between Job and SSIS Pacakge

  

HI All,

I have created package in SSIS which process the cube in Incremental mode,but what problem i am facing when i run the package first,its runs successfully but not updated the cube while when i run the package secind time it upload the data in to the cube and this happens regulrly.

This happens with processing mode too. 

Kindly Suggest what mistake i have commited.

 

Shraddha

 


SortPropertiesAttribute for Custom SSIS task issue?

  

Hi

I have decorated internal node class with

[

SortProperties(new string[] {"Name","DisplayText","Description" })]

 

in

Issue with Connection of Sybase in SSIS and Linked Server in SQL Server

  
Iam having problem connecting with Sybase from SSIS or Link Server of SQL Server 2008.

 I have installed Sybase 12.5.1 OLE DB Driver and have also registered by running command:

 C:\sybase\DataAccess\OLEDB\dll>regsvr32 sybdrvoledb.dll

 We are also able to create System DSN from ODBC Administrator in Windows 7. I am also able to import data in the MS Access. Here is the System DSN I created, successfully.

 I would really appreciate you can help us out.


SSIS Parameter Mapping Issue

  

Hi , we are facing a strange issue while executing one our SSIS package. It works on all enviroment excep one. We have checked the software and hardware stack. It is similar to other enviroments. This SSIS is triggered by a ASP.Net application. 

1. The issue comes in Paramter mapping in sql execute task. I need to Map a user variable of type int32 to Numeric datatype. It thows a error "invalid precision value". The same code works on all enviroments except this one. If i change the datatype to Short or Varchar, it works perfectly. Not sure why Numeric fails only on this Enviroment ?

2. But if run the SSIS as a standalone task, instead of trigerring it from ASP.net app, the int32 to numeric mapping explained above works even on this enviroment. So not sure why triggering the ssis it from asp.net fails.  Would there be any diffrence if we run the SSIS through a client or as a standalone.?

I know its a Enviroment issue. But not able to get to the root cause.  any pointers would be really helpful.

 

regards,

Mahesh

 

 

 

 


SSIS 2005 Buffer Manager Issue

  

Hi All,

I am facing Buffer Error while running my SSIS Package. I have configured BufferTempStoragePath Property of Data Flow task. Even though I am getting the following Buffer Manager Error.

Description: The buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property. There is an incorrect file name or no permission.  End Error  Error: 2010-09-24 07:40:01.01     Code: 0xC0047048     Source: DFT Load Fact Data DTS.Pipeline     Description: The buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property

Is there any other property settings or workaround to resolve the issue?

Thanks,

Guru


Help! Truncation Issue in SSIS with DT_NUMERIC!!!

  

Hi,

I'm simple going nuts, trying to resolve this problem.      So I have text file (flatfile) with some potential numeric data (Something like 0000059856) .  Now this is part of a large string in the text file.   My goal is to retrive this data and convert into the following 0000059856 / 10000.0 = 5.9856.    And then push the values to SQL Server table (So in SSIS data folow I have flatfile source --> Derived Column -->SQL Destination) .   The SQL Table column is defined as numeric(20,4).     In SSIS I used "Derived Column flow task" to extract the column and then convert and apply the computation ( / 10000.0).   So something like ((DT_NUMERIC, 16,4) (Column0)) / 10000.0.  But ultimately what I get in the SQL Server table is 0.50000.   I've tried several options and couldn't really tell.  I even used DT_DECIMAL,4.  But that doesn't seem to work.    What I need in the table is 5.9856.   I saw some similar issues on google about DT_NUMERIC in SSIS truncating stuff, but no clear solution.   Any help would be great.

 

thanks

 


SSIS Custom Destination Component colum mapping issue

  

Hi ,

I am facing the below issue.

I am developed a custom destination component.I have custom UI also to set some properties.

Once i save the component and do the mapping in the Show Advance Editor Colum Mapping.This is working fine.

The problem starts Next.If I edit the component and do some changes  and say Ok ,In the output colum mapping all the mappings which i have already been set is getting removed.Then again i have to remap it.Ho to keep the existing mapping if we edit the component?

need help to solve this issue.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend