Integration Services :: SSIS 2008 Randomly Ignores Debug Breakpoint?

Oct 12, 2015

SSIS 2008 when I develop and debug in BIDS sometimes ignores debug break point.

The script component is in the main control flow and at some point the breakpoint did work.

If, for example, I create a new project and copy my script component there the debug breakpoint will work.So it's absolutely *random* when it works and when it does not.

Below is my BIDS detail:

Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: IDE Standard
Enterprise Library v5 Configuration Editor   4.0

[code]....

View 2 Replies


ADVERTISEMENT

Debug Not Stopping At Breakpoint

Nov 25, 2011

I'm trying to debug stored procedure code with SSDT, but the debugger don't stop at the breakpoint.

I imported the schema of northwind database from Denali to a new database project and used Run to publish it to localdb.

So, I inserted a breakpoint in SalesByCategory stored procedure, opened a new query window, write an execute statement and started the execution with debug.

The debugger stop at the exec statement, but never get into the stored procedure. I'm using a breakpoint in the stored procedure, already tryed F5, F11, nothing works.

Application Debugging option in localdb is checked.

The operating system is windows server 2008 R2. I'm still using CTP 3.

Did I forget to check/do something ?

View 2 Replies View Related

Integration Services :: SSIS 2008 - Using A 64bit ODBC Connection?

Sep 21, 2015

I'm running SSIS 2008 (VS 2008) on a windows server 2008 R2 server. I added a new ODBC driver (Specifically for SAP HANA) and then configured  and successfully tested an ODBC System dsn in the 64 bit odbcad.exe.

Unfortunately when I go to use this system dsn in SSIS 2008, the  "Configure ODBC Connection Manager" is empty. After some research it appears that by default SSIS 2008 (or at least my particular instance for whatever reason) brings up the list of installed ODBC drivers/User and System dsn for 32 bit (C:WindowsSysWOW64odbcad.exe) instead of the 64 bit connections (C:WindowsSystem32odbcad.exe). I'm wondering if there is a setting somewhere where i can tell SSIS to use the 64bit connections by default in lieu of automatically going into C:WindowsSysWOW64odbcad.exe or if there is some other work around here ?

View 5 Replies View Related

Integration Services :: SSIS 2008 R2 Set Values Does Not Work As Intended

Oct 13, 2015

At one of my accounts I'm using SQL 2008r2 and SSIS in an DWH solution. Today I wanted to created a dynamic sql statement in one of the packages. The dynamic part is in the where-clause a sql query I use. I want to set the values for this clause dynamically. Therefor I created a user variable (named 'Filter') which should get it´s value at run-time.

/DTS "MSDBProdMy Package" /SERVER "My-Server" /CHECKPOINTING OFF /REPORTING EW /SET "Package.Variables[User::Filter].Properties[Expression]";" where [Starting Date] < '2008-09-01 00:00:00.000' "

However when I execute this package with dtexecui it doesn not use the value specified after the /SET parameter, but instead uses the value specifiied at design time. I get the same when I add the execution of ths pacakage as a sql server job step (type SSIS).  I would expect that value specified after the /SET parameter would overwrite the valus specified at design time, but I don't see that happening.

View 5 Replies View Related

Integration Services :: SSIS 2008 / Turning Delimited List Into Table?

Sep 30, 2015

I have list (in an input file) where each row is about 20K in size (so it can't be stored in a sql table). I want to convert the list into a table as shown below:

before:
---------------
pk1,  c1, d1, c2, d2, c3, d3,......
pk2   c1,d1,c2,d2,c3,d3.....

where "pk" denotes a primary key and in a given row (c1,c2.c3,...) are all distinct. ("c" are columns names, "d" is the associated data)

after: (desired conversion)
---------------
pk1,c1,d1
pk1,c2,d2
pk1,c3,d3
...
pk2,c1,d1
pk2,c2,d2
pk2,c3,d3
....

I was planning to have SSIS pull in the "before" data, run a custom C# program in SSIS against it to massage the data to vertical (3-column format), then export the massaged data to a new text file. The new text file would later be imported into a sql table using SSIS. 

View 5 Replies View Related

Integration Services :: SSIS 2008 R2 Package Is Pushing Data Down In Excel 2010 64 Bit

Jul 2, 2015

I have package which pulls data from db table and creates a excel file extract.The flow is like this - A excel file template sits in the input folder folder for processing .The package starts by dropping excel sheet in the excel(which is clearing any data and columns available) once that is done it has script task which creates a new columns for the sheet and gives a sheet name as well .Then a execute sql task runs and pumps data into a table which  serves as a source for the excel extract process .The excel extract process involves pulling data from the table and doing data conversion before it moves it into the oledb destination (excel file on file server).When I run the package I go and see that data is pushed down . I see top rows say 100 are empty and data appears after say 100 rows .

I tried deleting excel file and replacing with new one empty with columns and sheet name only but still it doesnt work?I am trying to understand what is making ssis behave like this and what can I do overcome the problem ?I read on google that we need to bring in file system task will move a template to working directory which is input folder but I dont want it to incorporate that logic as we need to push this package to production ASAP with very minimal change.

View 3 Replies View Related

Integration Services :: How To Split Excel Workbook Into Individual Sheets Using SSIS 2008

Jun 29, 2015

How to split excel workbook into individual sheets using SSIS 2008 without using  " Microsoft.Office.Interop.Excel"

The Workbook need to be broken into multiple sheets available in the workbook.

The SSIS package will read the excel workbook and split into individual sheet  and rename the sheet with the name available in the workbook..

View 6 Replies View Related

Integration Services :: Excel Source On SSIS 2008 Brings Null Values

Apr 20, 2010

I'm trying to import some XLS files that I receive from some suppliers. The problem is that every time they send some columns with text values but formatted as number. When I read those columns with SSIS Excel Source, they come all with null values.

I don't want to change the columns data types every time, so I would like to know if there's a way to bypass the column types that are already there.

I tried to use both the Jet driver and the Office 12 driver. I've already used the IMEX=1 on ExtendedProperties too with no success. Is there a way to force reading the columns as text, even if they have data types assigned to them?

View 15 Replies View Related

Integration Services :: How To Import Json From HTTP Request Into Table By Using SSIS 2008

Oct 29, 2014

I know parsing json data has been discussed lots but what I want is probably a little simpler or different:

I have a URL where I can open and get the Json data.

I need to parse and load the Json data into a SQL table, and I want to use it in SSIS, not using C# or VB.NET coding.

I am on Visual Studio.NET 2008 and SQL 2008R2

View 4 Replies View Related

Integration Services :: SSIS 2008 R2 - Add Columns To Existing Mapping With Destination DB Table

Sep 8, 2015

The only way to add a new column to an existing mapping that I know is to go to advanced editor and refresh. This however keeps only the default mapping (where the field names match), the rest is wiped out, so need to restore the mapping manually after that. Risky and annoying at the same time. Is there any alternative?

View 3 Replies View Related

Integration Services :: Loading Multiple XML File With Different Metadata In Server Tables With SSIS 2008

Feb 17, 2011

I have multiple xml data file in a directory say C:XMLData abc1.xml, abc2.xml, abc3.xml etc.

Need to loop through each file in ssis with Foreach loop container, and get the file name say abc1, and load the data of abc1.xml to abc1 table in sql server DB.

Next iteration will pick up the abc2.xml and find the abc2 table in sql server DB then insert the data in abc2 table.

While each iteration, xml source should also point each xsd file correspondingly.

 Tables are already created in DB

I solved my problem up to getting the file name from ech iteration and assigned file name to variable, in oledb destination data access mode I select Table or view name variable, then corresponding table will get selected for data insertation.

Just wanted to know how can I read each xsd file for each xml data files while iteration. 

View 12 Replies View Related

Integration Services :: SSIS Fails To Load Files From Network When Executed Via Agent (2008 R2 SP2)

Aug 5, 2014

I have a simple SSIS package that reads a flat file and copies it into a SQL Server table.

When the flat fiel is on the C drive I have no problem runnign this package from SQL Server Agent, but as soon as I update the path to a network location the package only works when I run it manually, but fails when is executed via the SQL Server agent job.

The error says "cannot open the datafile", while the datafile location is valid.

Is this a kind of limitation of a SQL Server Agent that only local files are allowed to be processed?

View 4 Replies View Related

Integration Services :: Can't Debug Script Task

Jun 27, 2015

i set break point in Script Task, but the process didn't stop.

environment : SQL Server Business Intelligence Development Studio 2008

how to solve this issue ?

View 3 Replies View Related

Integration Services :: Excel Column Turns To Blank / NULL While Import Using SSIS Excel Source 2008

Jul 6, 2015

While importing data from Excel source , some column is getting null value even though excel column has value.To Resolve the issue we tried with

HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice14.0Access Connectivity EngineEnginesExcel

1.Change the Value  of the Row TypeGuessRows from 8 (Default value) to 0  and ImportMixedType = text

• xls
HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesExcel

1.Change the Value  of the Row TypeGuessRows from 8 (Default value) to 0  and ImportMixedType = text

the connection string of the excel

UPPER(REVERSE(SUBSTRING( REVERSE(@[User::VarInputExcelFile]), 1, 5) ) ) == ".XLSX" ? "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::VarInputExcelFile] + ";Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";":"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + @[User::VarInputExcelFile] + ";Extended Properties="EXCEL 8.0;HDR=Yes;IMEX=1";"

by doing the above setting also , the column is coming as null from excel source even though there is data in excel.

View 2 Replies View Related

SQL Server 2008 :: Usage Of Built-in Functions On Columns Ignores / Excludes Indexes On That Column?

May 25, 2015

Somewhere i read..that in SQL Server...usage of Built-in Functions on Columns, makes query optimizer to ignore indexes on that column...!

So lets say we have table EMP with Emp_id and Emp_Name....

Also we have Non-Clustered index on Emp_Name.

So following query would NOT use Non-Clustered index on Emp_Name column.

SELECTLEFT(emp_name, 3) as emp3
FROMdbo.EMP

Is this true? i am using SQL Server 2008.

View 4 Replies View Related

SSIS Crash On Breakpoint Deletion

May 23, 2008

I'm having an issue with trying to delete breakpoints in my SSIS package. I think the breakpoints were created when I added dataviewers through my process, however the breakpoints were not deleted when I removed the dataviewers. It would then appear that my process would not halt on ANY breakpoints - orphaned or valid.

Furthermore, whenever I tried deleting the breakpoints manually, my whole IDE would crash. I got around the issue by closing the dtsx page first, then deleting the breakpoints, and reopening my dtsx.

Are these valid bugs with SSIS? Has anyone else experienced this? I'm running this against a SQL Server 2005 database using VStudio 2005 as an IDE.

Thanks!
Chris P

View 2 Replies View Related

Integration Services :: Load Flat Files From S3 Into 2008 R2?

May 12, 2014

We have a few customers dropping files in Amazon S3. how to load this data into SQL Server 2008 R2 database using SSIS? We are 2008 R2 BIDS environment.

View 5 Replies View Related

Integration Services :: Unable To Add Reference In BIDS 2008

Dec 8, 2008

I am trying to build packages Programmatically, added a Script Task and tried to add some references from DLLs. I got an error message showing that there is no template found, and from the event viewer of windows which tells me to run 'VSTA.exe /installvstemplates'  or 'devenv.exe  /installvstemplates'. I have run these two command and reinstalled the SQL server 2008, but still unable to add any references to the project.
 
The error msg:
 
---------------------------Integration Services Script Task---------------------------No template information found. 

See the application log in Event Viewer for more details.

View 22 Replies View Related

Integration Services :: Executing Child SSIS Package In Parent SSIS

Oct 9, 2015

I want to achieve the following in (SSIS/SSDT for SQL 2012) - 

I have a generic SSIS package which simply sends out email notifications using SMTP email task (this package is within its own project, and has project level input parameters).

I need to be able to call this package in the Event handler section of every package (numbering in about less than 60) that we have. These packages are within their own respective projects.

I thought I could use the "execute package task", but it turns out , using this, I cannot call a package that is part of some other project. I also cannot call a package that is stored in the CATALOG. Is there any way I can do this ?

When I call the child package , I should be able to send in parameters like - error information and package name of the Parent package.

View 8 Replies View Related

Integration Services :: Using 2008 Native Client 10.0 Provider To Connect 2012 DB?

Jul 9, 2015

In our packages, we are using Microsoft SQL Server Native Client 10.0 provider to connect our SQL Server 2008 DBs, which is working fine till we are migrating 2008 DB server to 2012. after the upgrade, some of our packages are working fine, some are not. I'm just curiuos to know will the
old provider(Microsoft SQL Server Native Client 10.0) will work fine for connecting 2012 DBs? or I need to update all our packages to re-point to new 2012 Provider.

View 5 Replies View Related

Integration Services :: 2008 - Script Task Break Points Not Removed When Choose To Remove All In Package

Jun 11, 2015

On the main BIDS menubar, there is a menu for Debug.  If I select Debug > Delete All Breakpoints, any breakpoint in a script task is still there afterwards.  Is there a way other than opening the script task and removing it there?

View 3 Replies View Related

Integration Services (SSIS)

Jul 25, 2007

Hi,

I want to insert datas from a txt-file into a sql-table.
Therefor i would use a xml-file for the structure!

How can i refer this xml-file to a measurement insertion task?


Tanks for your help and sorry for my bad english :rolleyes:

View 1 Replies View Related

Integration Services :: How To Use UDF In SSIS

Oct 23, 2015

I want to use UDF in SSIS where function accept 4 parameter value and return 1 value.

How can i achieve that. I need workflow.

View 13 Replies View Related

Integration Services :: If Condition In SSIS

Apr 30, 2015

How to achieve the below condition in ssis

if person_id  is like '123%' or '124%'
then details='xyz'
else details='yxz'

View 7 Replies View Related

Integration Services :: SSIS CPU And RAM Sizing

Oct 20, 2015

if there is any way to accurately size a single server using SSIS.  The server will be a virtual machine.  The data being loaded will be approximately 200 MB per load with loading to a 150 GB database on a separate server.

View 3 Replies View Related

Integration Services :: SSIS Job Schedule

Aug 31, 2015

I have scheduled SSIS package through Sql Agent and when I right click on job start job as step package runs successfully but when I schedule job it dosent run.

View 12 Replies View Related

SQL Server Integration Services(SSIS)

Nov 14, 2007



Can anyone help regarding the SQL server integration Services(SSIS), ETL
We have requirement like this:
We have Live Database( LIVE_DB ) and Reports Database (REP_DB)
I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSIS
If any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.

Thanks in advance, if anyone help me in resolving this issue.

Regards,
Bhushanam.



View 3 Replies View Related

Integration Services :: SSIS Failed At Last

Apr 20, 2015

I have a maintenance plan which consist db full backup and log backup ( in two subplans), I execute both on SQL agent, and both failed.The DB Log Backup : DB FULL BACKUP LOG:

View 14 Replies View Related

Integration Services :: Use Windows Authentication In SSIS

Jun 17, 2015

I have a ssis package with an oledb connection using windows authentication. i want to understand when i promote this package to the server and add it to a job, then a user login to the server with sql server authentication and run this job. Which/what  windows authentication this package gonna to use to connect to the server ?

View 3 Replies View Related

Integration Services :: Convert Seconds To HH:MM:SS Using SSIS

Oct 7, 2015

converting seconds to HH:MM:SS using SSIS.  I know how to do it in T-SQL.

View 13 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

Integration Services :: How To Design SSIS Package

Nov 21, 2015

Win 7 SP1 x64 PC. I installed SQL Server 2014 Dev Edition + Visual Studio 2015.

I'd like to create some basic ETL SSIS packages, and I worked very comfortably in 2008R2.

For 2014, I started with this tutorial:[URL]However, it says to go to Start->All Programs->Microsoft SQL Server->SQL Server Data Tools. 

I did explicitly install SSDT when I installed VS2015.  I also installed it separately.  I see SSDT listed in Programs, and SSIS is running according to SQL Server Config Manager, and Services.  Half of Microsoft's docs seem to be 2012 era, which is a shame because 2014 is out and it's nearly 2016...

how do I get to the GUI where I can design ETL packages? 

View 7 Replies View Related

Integration Services :: Using SSIS To Populate Excel

Sep 25, 2015

We'll be using 2014 enterprise to populate some excel spreadsheets.  We may not have the option of using ssrs so here is the question.

The excel spreadsheets have some pretty fancy heading structures, multiple tabs and in a few cases graphs that i'm sure are dependent on data sitting somewhere in the spreadsheet.  The heading have variable info in them (eg FYxx where xx is a parameterized fiscal year, month names etc).  Sometimes those headings have sub headings (with variable info) and so on.

Generally speaking how (if at all) do folks deal with this kind of excel challenge when limited to using ssis? I don't know if templates are going to be a good idea. I don't know if i'll be looking at a fair amount of c# etc code behind the scenes. I can be more specific depending on the feedback.

This is part of a conversion from 2 of the larger BI and statistical tools out there to the MS sql stack.  Obviously with some shortcuts that we may wish we didn't take.  

View 5 Replies View Related







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