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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Compatibility issue between Job and SSIS Pacakge

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
 
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  


View Complete Post


More Related Resource Links

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

 


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 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)

Linq forward compatibility issue

  
In Linq 3.5 I used to be able to do this, but the code in bold is no longer compatible in Linq 4.0, Is there another way to declare the query variable prior to assigning it (PLEASE DO NOT SUGGEST TO DECLARE AS VAR, IT DOES NOT WORK AND CAN NOT BE DECLARED AS NULL):   ProjectArtifactsDataContext dbProjectAttributes = new ProjectArtifactsDataContext();IQueryable<ProjectArtifacts.Defect> query1 = null;   This type of declaration allowed me to create aggregate and complex queries such as         if (UserControlHost.ShowMyItemsOnly)        {            Guid currentUserId = (Guid)Membership.GetUser(Membership.GetUser().UserName).ProviderUserKey;            query1 = dbProjectAttributes.Defects.Where(defect =>                 defect.Active == true && defect.AssignedTo == currentUserId);        }         else        {            if (FilterInactive == true)                que

Outer join operators *= and =* are not supported in 90 or later compatibility modes Upgrade issue

  
Hi all In processes of upgrading SQL Server 2000 to SQL Server 2008 I held up with one issue I am not a good pragrammer If some helps me how to modify this query,realy it help for me. "Outer join operators *= and =* are not supported in 90 or later compatibility modes" Here this query SELECT Brnd.Name, Dev.Devype FROM Prd,PrdRel, Rel, RelVer, DevSoft, DevCla, Dev, Brnd,OVer WHERE Prd.ID = PrdRel. Product AND Rel.ID = PrdRel.Release AND RelVer.Release = Rel.ID AND DevSofte.ReleaseVersion = RelVer.ID AND DevSoft.DeviceClass = DevCla.ID AND DevCla.ID = Dev.DeviceClass AND Brnd.ID = Dev.Brand AND OVer.ID =* Dev.OSVersion AND RelVer.Latest = 'Y' AND Prd.ID = @Product AND Rel.OS IN (@OS) Please some help me how to code  to come out from the problem. your help going to be greate for me.  SNIVAS

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

SSIS Environment Issue

  

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?


Browser Compatibility Issue : Telerik

  

Hello everybody.

At the beginning I want to tell that I searched Google to find my solution but I failed.

I am working with Telerik for my college project. But I figure that there is a browser compatibility issue arise.  I am showing a table layout of Login Control :

<asp:Login ID="Login1" runat="server" OnLoggedIn="Login1_LoggedIn">
										<LayoutTemplate>
											<table cellpadding="2px" style="margin-left:auto; margin-right:auto">
												<tr>
													<td align="center" colspan="2">
														<asp:Label ID="LoginLable" Font-Underline="true" runat="server" ForeColor="Black"
															Text="Log In">
														</asp:Label>
													</td>
												</tr>
												<tr>
													<td align="left">
														<asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="UserName" ForeColor="Black"
															Text="User Name:"></asp:Label>
													</td>
													<td align="right">
														<telerik:RadTextBox ID="UserName" runat="server" Skin="Custom&q

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

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


"Version90 database compatibility level is not supported." After SSIS Destination Upgraded from 2005

  

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.

This leads to several questions:

1)     

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