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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Preview problem in SSIS

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server
Good Day,

A small doubt...Whenever i,am assigning  Source to the Excel Source, in the "Excel Source Editor wizard" there is "Connection Manager",in this we can assign our source,after assigning, there is a Drop Down button which name is "Name of the Excel sheet", when we click that button there is always two excel sheet names will be there as like sometimes Scenario1)" Excel_Destination, Excel_Destination$" sometimes Scenario2) "Excel sheet name","Excel sheet name$" and sometimes Scenario3)"Data", "Data$".I don't know what is the reason.If there is Scenario1...when we click"preview", it shows error. If there is Scenario2...when we click "preview", it shows only column headers.If there is Scenario3...when we click "Preview", it Shows perfect, i mean, the Excel sheet which i selected.Can you please guys tell me about this issue.

Kind Regards

View Complete Post

More Related Resource Links

Strange Problem - SSIS Fails with "Syntax error, permission violation, or other nonspecific error".

Hello, I have a strange issue while I am deploying a package to one of the environment server. I have 2 XML Source, in the DataFlow, and one will extracted based on a value of variable that is passed from run time (package is executed from a Job) and other will be extracted all time. The next Step I have is a Execute SQL Task in ControlFlow wihich will execute after DataFlow. This has 2 input parameters and some SQL query that uses the param. Now this one fail on the target environment with below error: failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I got the error when I did a SSIS Text File Log. Note: If I run the package in BIDS with the same XML files it work. Also when I deploy the package to my Dev Server it works. When I compare the Dev DB with the target environment DB - Both are same. The Service Acount has permission - as I can see the DataFlow task completed. Another Point: The XML Load Data Flow that executes based on the Variable Value does not execute on target environment, even if the value is passed as "True" (It is Boolean Type) But this variable is NOT an input for the Execute SQL task that fails. I am not sure w

Problem importing text files with binary zeros (0x00) via SSIS(SQL2005). It is all fine when using D

Hi.   There is a "text" file generated by mainframe and it has to be uploaded to SQL Server. I've reproduced the situation with smaller sample. Let the file look like following: A17     123.17  first row          BB29    493.19  second             ZZ3     18947.1 third row is longer And in hex format: 00:  41 31 37 20 20 20 20 20 ? 31 32 33 2E 31 37 20 20  A17     123.17  10:  66 69 72 73 74 20 72 6F ? 77 0D 0A 42 42 32 39 20  first row??BB29 20:  20 00 20 34 39 33 2E 31 ? 39 20 20 73 65 63 6F 6E     493.19  secon30:  64 0D 0A 5A 5A 33 20 20 ? 20 20 20 31 38 39 34 37  d??ZZ3     1894740:  2E 31 20 74 68 69 72 64 ? 20 72 6F 77 00 69 73 20  .1 third row is 50:  6C 6F 6E 67 65 72       ?                          longer          I wrote "text" in quotes because sctrictly it is not pure text file - non-text binary zeros (0x00) happen sometimes instead of spaces (0x20).   The table is: CREATE TABLE eng ( src varchar (512) )   When i upload this file into SQL2000 using DTS or Import wizard, the table contains: select src, substring(src,9,8), len(src) from eng <               src                ><substr>             <len> A17     123.17  first row           123.17                  25BB29                                493.19                  22ZZ3     18947.1 third row           18947.1                 35   As one can see, everything was importe

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Who can come up with a good SSIS solution to this problem?

Test your SSIS optimization skills on this problem: http://ask.sqlservercentral.com/questions/17499/phil-factor-speed-phreak-challenge-6-the-stock-exchange-order-book-state-problem Johan Åhlén http://blogical.se/blogs/jahlen  

Problem with Merge Join and condition splt trasnformations in SSIS 2008

  Hey, While working SSIS in 2008 we have encountering some weird problems with Merge, Merge Join and Condition Spilt transformations, here are the details... Condition Split and Merge Join and Condition Split: Please check the below diagram(not really just tried) for the complete details. Just FYI data is in sorted order   condition Split -> 420000      | 18                                                          | 419982  Merge Join(left)  -- src1(6000)      |10  Condition Split      |9     |1   the merge join transformation is not returning the complete 18 rows to the next transformation that's why we are missing 8 rows. But if we adds a sort transformation (getting warning as data is already sorted) before merge then complete 18 rows were passing to the condition split. Also tried modifing the source query just to return 18 rows then also it was passing the 18 rows to next trasnformation except with full load.       Merge: We have two sorted data sources and first one has 40000 records and second source have 12000 records and after the Merge transformation we have Condition Split transfor

Index droping problem in SSIS package?

Hi All, I have one ssis package. After load the staging data I am creating index in one column. I am dropping the index end of package. But sometimes after create the index if I got any error I need to re run the package, already index is created so that’s why  once again I will get a error. So that purpose drop index statement I used before create index sqltask.If the first time package runs the table don’t have index. If the table have index it will drop the index otherwise it will skip that task. I used below code. But I am getting the error index is not dropped properly. IF EXISTS (SELECT name FROM sys.indexes WHERE name =   N'IND1_TRAN_DT ')  DROP INDEX  IND1_TRAN_DT  ON SLS_STNT_DTL_STGNG;   Thanks CMK

Problem running SSIS package in Jobs

Hello friendsI'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?thanks in advance.

Problem using SSIS to move DB2 data to Oracle



I will need your advice on a SSIS package which moves IBM DB2 (for z/OS V7) data to Oracle (AIX 10g). Thank you in advance.

Basically, this is a very simple SSIS package (created by SSIS import / export wizard) and just maps column by column. I used IBM OLEDB provider for DB2 to connect the source and Oracle Provider for OLEDB to connect to the destination.

The problem I ran into was that if the DB2 source value contains special (or invisible) characters then this value will be converted to a SPACE (' ') value on Oracle. To be more detailed, take the following example:

On DB2, value  000002D0000002D7 (EBCDIC HEX codes). This is actually a value of a column defined on DB2 as CHAR(8). Please note HEX '00' in EBCDIC stands for NULL and HEX 'D0' stands for character 'K';

On Oracle, this value will be stored as a SPACE (or a string of SPACEs) after data move.

On both DB2 and Oracle this column was defined as CHAR(8).

I guessed this was related to a code page issue, so I tried a few different code page to set for the source property (by setting the DefaultCodePage of the DataFlow source property), I used code page 37, 500, etc... All resulted in the same Oracle value.

The character set on DB2 is EBCDIC and the one on Oracle is ALT32UTF8. I guess it was the source provid

SSIS Script task design script problem



  I have placed a script task in my SSIS project, package.

When I click Design Script button, script editor is not opening, instead its returning to Control Flow. But no error.

 What is the problem?

I just created a new folder in D:\ drive with the name My SSIS. 


CompilationMode problem in ASP.NET MVC 3 Preview 1


This is for fellow programmers who are using ASP.NET MVC 3 Preview 1 - keep informed.

Yesterday, I was experimenting with ASP.NET MVC 3 Preview 1 and came across a situation, where ASP.NET build manager throws an exception that it could not create the requested view. It does not say - WHY!

This problem does not occur in ASP.NET MVC 2.0 & ASP.NET 4.0 combination. Logically, the GetCompiledType method is doing what it is intended to do - return the compiled type of a page if it is really a compiled/compilable type. But there is some fault in the logic in the upper levels - where the returned result is used to create the view instance. It should also be able to create a non-compiled view - as in the ASP.NET MVC 2.

Details on http://blogs.callosmart.com/2010/09/28/compilationmode-problem-in-asp-net-mvc-3-preview-1/

Somebody from the MVC 3 team can comment on this problem.

problem with import from CSV in SSIS


Hi all,

i have a strange problem, i am trying to create a import package to import data from a CSV file.

When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent.

When I open the CSV in excel or a other program it looks good, all rows are ok.

When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies.

Does anyone have a idea?


all the settings are standard.

The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.





MVC 3.0 preview 1, Html.RenderAction Problem


Hi all,

I'm trying to use Html.RenderAction with MVC 3.0 preview 1 and i'm getting an error. i have the following controller:

	public class HelpController : Controller
public ActionResult Detail(int id)
ViewModel.Title = "Help Title! " + id.ToString();
ViewModel.Content = "Help Content!" + id.ToString();

return View();

and in another controller, i'm trying to do:

@Html.RenderAction("Detail", "Help", new { id = 3 });

but i keep getting:
CS1502: The best overloaded method match for 'Microsoft.WebPages.WebPageUltimateBase.Write(Microso

SSIS deployment problem


Do we need to install Integration Services in order to run SSIS packages in file system?

Our production machine doesn't have SSIS installed. Today, I created an SSIS package in our Development Server. Now I want to be able to deploy the package into file system and run the package from SQL Job. Please advice.

Execution SSIS package in .NET: ADO NET Source with Expressions Problem

Hello Gurus!

We try to execute our SSIS packages from a .NET application. It works fine until we use “Expressions ” inside Data Flow’s components like “ADO NET Source” (e.g., for building SQL statements)

I use the ADO NET Source Control and want to set the SqlCommand property with an expression holding a SQL statement.

When executing the SSIS package in Visual Studio (in debug mode) I get no problem, everything works fine. When executing the package from within my .NET application it crashes the app completely, only creating a generic Win32 Exception with no relevant information.

My steps:

1.       I created new SSIS package.

2.       Then added the Data Flow component.

3.       Inside Data Flow I added “ADO NET Source&

Problem deploying custom report item. Items shows in preview screen in VS, but not in server deploye


I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />

3. Updated the rssrvpolicy.config file with the following entry.

                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                                Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Uabr.Rap.PedigreeChart.dll" />

I've also tried using the StrongNameMembershipCondition

Razor View Engine problem in Preview corrected in Beta?



On my projects I am using Razor View engine and I need to define custom Partial folders:

      // Define default view engine
      ViewEngines.Engines.Add(new CshtmlViewEngine());
      ViewEngines.Engines.Add(new WebFormViewEngine());

      // Define Razor view engine
      CshtmlViewEngine razor = (CshtmlViewEngine)ViewEngines.Engines[0];

      // Register partial views folders                
      razor.PartialViewLocationFormats = razor.PartialViewLocationFormats.Concat(new String[] { "~/Views/Partial/{0}.cshtml" }).ToArray();
      razor.AreaPartialViewLocationFormats = razor.AreaPartialViewLocationFormats.Concat(new String[] { "~/Areas/{1}/Views/Partial/{0}.cshtml" }).ToArray();

I had this because there was a problem in MVC 3 Preview. Was it corrected?

How should I register the Partial Views in MVC 3 Beta?

Thank You,


SSIS Configuration Problem?


Hi All,

I created one package.I executed that package through BIDS its working fine.I created one configfile.I am trying to execute the same package but i am getting the error like below

The product level is insufficient for component "rowcount"(16).Please help me in this issue.





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