Reusability && SSIS - Issues They Do Not Write In Books About

Feb 14, 2007

I have a simple requirement:

Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID.

Ok - I get that part about creating a custom task and so on for reusabilty.
But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc.

What is going to happen in that case?

Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version?

View 18 Replies

Reusability In SSIS?

Sep 1, 2005

Something in another thread spurred me to post about this, wondering if others have solved this, or what workarounds they might be using.

View 3 Replies View Related

SSIS Books

Apr 2, 2007

Hi,

I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.

If anybody knows any guide, please let me know

Aash.

View 5 Replies View Related

Books For SSIS

Sep 12, 2006

Hi,

Please give the Microsoft suggested book material list for learning SSIS

Thanks & Regards

S.Nagarajan

View 2 Replies View Related

Books On SSIS Programming

Jun 14, 2006

Hi,

Can you please suggest the books which cover SSIS programming in C#?

Regards,

Gopi

View 1 Replies View Related

Books For Scripting (.NET) In SSIS...

Apr 10, 2008

Could someone recommend good books for scripting with .NET in SSIS? Anyother useful websites that have this kind of stuff? Appreciate any help.

View 5 Replies View Related

Task Reusability

Apr 21, 2006

I have a same sql execute task that i want to use in all my packages, all this does is track the package name and its start time into a DB. So as i understand, if i create a package call "log start time" and use it in all my packages, the package name will not be correct. Anyway i can build this simple custom task, or any other solutions will be appreciated.

View 5 Replies View Related

Database Reusability With Sql Server

Jul 20, 2005

Hi,The company I work for often develops databases for clients. Thosedatabases always need to do similar tasks. One company might need adatabase to do task 1 and task 2, while another company might need itfor task 2 and 3. Instead of having to redevelop each database fromscratch, I'd like to be able to develop several "modules" (kind ofmini-databases) representing each of this task, and then chose themodules which are relevant. Then all I would have to develop would bethe final layer putting together all the information gathered fromthose modules. I'm sure this has been done heaps of time before but Ican't really find any information on it. Any of you have any pointersor experience you would like to share. I'd like to have a good thinkabout how I'm going to go about it, and the limitations that mightarise before I get stuck into it.Thanks for your help,Maelle

View 2 Replies View Related

What Is The Language Used To Write In SSIS?

May 17, 2007

I know very little (so far) of SSIS but a co-worker suggested that it was VB.NET used to write scripts in SSIS. Is this true, or is there a selection (maybe C# as an alternative), or is it some other type of script language?

From what little I remember of DTS, I thought it was a pseudo-VBScript language used to write code for it (but I can't really recall).

I would appreciate anyone getting it straight in my head.

Thanks,

Ron

View 3 Replies View Related

Integration Services :: Write Key Value Of Records Processed To SSIS Log?

May 5, 2015

What's the best way to write key values of records processed in my SSIS 2012 package to the log provider chosen?My SSIS package deactivates widgets as well as thingies. It was just released into production this week, runs daily, and we'd like to keep a close eye on what it's doing for a couple of weeks, by that I mean on any day be able to quickly see which thingies and widgets were deactivated that morning. It typically deactivates less than 5 widgets and thingies per day.

We could dig through the database to see which were deactivated, but that only works if somebody hasn't manually reactivated it since it was deactivated. We need a log. This is a temporary watch we're doing, so we don't want to write to a table or make make any significant package changes, such as adding new tasks.It seems like writing the 5-or-so deactivated thingy and widget key values to the log is the best way to watch this package. What's the most efficient way to do this? I'm hoping to avoid a new loop and script component with "Dts.Log" calls, but I don't know any other way.

View 3 Replies View Related

How To Write Condition In The Conditional Split Control In SSIS

Aug 25, 2006

HI i need to write the Condition for Insert and Update Reccord depending upon the Prod_ID. How to write the Follwing condtion in the Condition Split? pls Anyone give me the Solution?

" if Prod_ID Exist then UPDATE Records

if Prod_ID Not EXIST then INSERT Records "

how to write the above conditon in the Condional Split?

Thanks & Regards,

Jeyakumar.M

chennai

View 10 Replies View Related

Attempted To Read Or Write Protected Memory Error In SSIS

Mar 17, 2006

I'm trying to import data from a Sybase ASE 12.0 database called "OurTestDatabase" into MS SQL Server 2005. I started SSIS Wizard and indicated "Sybase ASE OLEDB Provider" as a source and SQL Native Client as the target. I'm gettign the following error message:

-----------------------------------------------------------------------------------------------------------------

Cannot get supported data types from the database connection

"Provider=Sybase.ASEOLDEDBProvider;Password=;Persist Security Info=True;User ID=sa;Data Source=sybase;Initial Catalog=OurTestDatabase"

Additional information

|_ Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (System.Data)

-----------------------------------------------------------------------------------------------------------------

The same data source worked with DTS when we thought we'd convert to MS SQL Server 2000. Is this a bug in SSIS? What can be done? Using ".Net Framework Provider for ODBC" is not a good option because this doesn't allow me to choose any tables from the Sybase source.

Any help is greatly appreciated.

View 7 Replies View Related

Is Ssis The Only Technology That Can Read/write Raw Data Type Files?

Sep 21, 2007

I'm contemplating a sql server archive strategy that rolls really old data off any sort of dbms and onto low cost media like dvds in a non relational archive format. I dont want to ever worry about these archives spanning different versions of sql when i go to retrieve a range of data that happens to span sql versions (eg one disc was sourced from 2005 another by 2008 but my report needs a union of both).

So I'm thinking about neutral/efficient formats for these archives and a live homegrown catalog that can determine exactly what disc(s) need to be mounted based on passed from and to date parameters...all so that the data that might span discs (and versions and maybe even schemas) can be merged and loaded into my sql version d'jour's "throw away" archive database for a one time report or other unplanned activity.

I remember raw data types being very convenient as an ETL format for our customers who have ssis, but wouldn't want our sqlexpress customers to be left without the archiving capability. Do the "things" that read and write raw data files really originate in some special T-SQL command that all sql editions can use, or is it strictly an ssis thing?

View 4 Replies View Related

Integration Services :: Write A Select CAML Query With Where Clause In SSIS?

Sep 17, 2015

I have 3 columns in my SharePoint list. I wasn’t to select the max date for a particular condition. How to write it in CAML?So from the below table I want to get the max date for column 1 when the value is A or B

View 3 Replies View Related

Error While Trying To Assign A Value To A Read Write Variable In SSIS Package Script Component

Sep 26, 2006

Hi,

I am trying to develop a SSIS package which will read the records from the flat file and insert them into a destination table. I have some validations written in script component. I have declared two Read Write variables with package level scope. when i try to assign a value to the variable in the script component and run the package, the package throws me an error "The collection of variables locked for read and write access is not available outside of PostExecute".

What should be done to over come the problem please help me on this regard

Thanks

Madhavan.M

View 15 Replies View Related

Backup Master Key, Cannot Write Into File 'c: Empmaster'. Verify That You Have Write Permissions, That The File Path Is Valid.

Jul 12, 2006

Hi,

I tried to backup the master key by the following syntax :

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'mypassword'

BACKUP MASTER KEY TO FILE = 'c: empmaster' ENCRYPTION BY PASSWORD = 'mypassword'

but it failed and i got the following message:

Cannot write into file 'c: empmaster'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

NB: I am using the "sa" user to execute this command.

I know that we have a security permission issue , but where and how ?

Regards,

Tarek Ghazali

SQL Server MVP

View 12 Replies View Related

Books

Sep 2, 2004

any all-rounder good book on SQL Server

View 1 Replies View Related

SQL Books

Aug 11, 1999

I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.

View 1 Replies View Related

SQL Books

Aug 11, 1999

I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.

View 1 Replies View Related

Sql Books

Feb 5, 2002

Hi,

I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.

Want something that gives you recommendation about better practices for performance issues for writing SPs.

I read all the reviews on amazon and b&N . It's confusing to choose only two.

Any recommendations?

View 1 Replies View Related

Books

Sep 20, 2001

Can Anyone tell where I can found a tutorial about Transact-SQL ?

Thanks

View 1 Replies View Related

Books SQL

Sep 2, 2004

Hello, I wish SQL' Books.

Anyone help me..

Bye :rolleyes:

View 4 Replies View Related

Sql Books

Jul 20, 2005

hipls tell the site's where i can download free e-books,bye,s.premkumar

View 1 Replies View Related

Books

May 21, 2007

Hi , i am new to certifications in general..
I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes.
what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements?
what are the difference between the two e-learning and MS Press books?

View 6 Replies View Related

Books On Line

Aug 7, 2001

Hi,

I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.

Any help would be appreciated.

jim

View 1 Replies View Related

Books On SQL Administrations

Feb 28, 2000

Hi

I am looking for books on SQL 7.0 Administration. I would appreciate if any body could recomend.

regards
rajeev

View 1 Replies View Related

Books - For SQL Server 7.0 DTS

Nov 3, 2000

Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.

View 4 Replies View Related

Any Good DTS Books

Sep 30, 2002

Does anyone know of any good books on DTS? I am currently using SQL 7.

Thanks in advance

View 2 Replies View Related

Any Good Books

Sep 14, 1998

Hi there,

Any good books to Know the internals of MS-SQL server 6.5

Thanks
Vivek

View 2 Replies View Related

Books Online

Aug 10, 2005

How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?

Thanks!

View 13 Replies View Related

CD, Books, Sites

May 24, 2006

naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me

Thank you"

View 3 Replies View Related

Nice Books?

Jun 14, 2006

hi guys,
i m a newbee in SQL. i wanted to know which is the nice book to start with? anyone got ebooks of SQL2005?

View 1 Replies View Related

Ref: Books/webcast On ETL

Oct 9, 2006

we are trying to build warehouse in our company its very small database but still.
we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday .
Now we have to stop doing that and just update the database and check for the changes in the existing data.
Can anyone suggest ETL book/webcast/weblinks that could help me.

Thanks in advance
Srini

View 1 Replies View Related

Reusability &&amp; SSIS - Issues They Do Not Write In Books About

Reusability && SSIS - Issues They Do Not Write In Books About