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?
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.
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.
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
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.
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.
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?
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:
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.
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?
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
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
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.
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.
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.
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?
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.
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.
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?
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
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.
