We have a NT service built via Visual Basic 6 which fires dts processes on demand according some criteria. Well, on the whole and basically only for the following rule:
-dts process is executed when our service recognize a concrete plain file leaved in a folder. It€™s generally generated for a mainframe JCL along with a activator file (.nul file, empty). Each application own a folder and each folder have lots of files as the aforementioned ones. Scheduler for that is an ASP application that lives within a intranet. It also is a monitor and logger
In that schema, keeping on mind that eight out of ten are ETL processes, critical ones and on daily-basis, our question is, how to handle on with this stuff using by sql25k and its powerful SSIS?? Migrating such dts packages to SSIS packages is a piece of cake (now no before; thanks Jamie, Michael and other guys for your awesome help) because of its tipology. However our main concern is what the hell to use. Centralized dtsx package running all day long as a service, listening and checking for files? .Net windows application either vb or c#? aspx solution? Set of .vbs interlinked among them?
This is a old post/goal. In spite of we have not defined any deadline for that, what the heck as time goes by is more urgent for us. A restriction: we can€™t to programme nothing from our sql25k production cluster physically. Any stuff will be done on workstations.
In terms of cost, no problem at all. We are interested in hear thoughts and point of view about which is the most effective way
I have another question I'm just looking for some opinions on this. I created a database through sql (sql engine, access 2000 client side) now this database has Hyperlinks in it which lead to the employee's documents which on in acrobat pdf. Does anyone for see an problems that might occur wth that???
I have had one tossed at me that I've never dealt with before. While I've done calculations on date parts I'm a little lost on how to proceed. They want a stored procedure that will take date from one field and add three days to it and that would update another field. The three days must account for weekend and holidays.
The date would be receiveddate 12/03/2007 and the due date 12/06/2007. If someone has run into this and has some sample code it would be a great help.
I just create FLATFILE connection manager from UI, and now I would like save this connection manager for future use. I am not able to do this and now I am really stuck in the middle of coding.
ConnectionManager class has SaveToXML and LoadFromXML methods from IDTSPersist, these methods are not for use, but I am able to save CM to XML, however not load. Every try for loading ends with error 0xC0011008. The XmlNode.Name == "DTS:ConnectionManager"
CM class is not serializable, thus standard .NET feature is not working, also is sealed.
IDTSConnectionManagerFlatFile90 of cm.InnerObject is not serializable either, because it is interface and cm.InnerObject cannot be cast to ConnectionManagerFlatFileClass because is the COM.
Is there any way, how to save and load ConnectionManager besides writing of tons of code for each of connection manager type?
I am able to save and load package with connection manager, but it is not exactly what I want. Also is there possibility to work with XML in packages, but this is not "right".
I need to test an HR application with a future date without changing the system date. If I just rollback the the date fields in the data, it may not work as the application itself might be using getdate() type of functions..
Any thoughts on how to do this w/o touching the system date setting?
I'm trying to migrate to VS2005 and prepare for future Windows Mobile releases. My app uses MFC, CCeDBDatabase, and RAPI from the desktop to sync with the device version of the app. Works great now, but I'm worried about how many different ways it will be broken in the future .
My questions - first, are we pretty certain that CEDB will NOT be supported after WM5? Next, is there, or will there be, a CCeDBDatabase class for EDB? VS2005 seems to know nothing about CCeDBDatabase. What should I be doing with the CCeDBDatabase; do I need to re-write everything using only API calls? Also, there is no RAPI for EDB, is this correct? If so how can I switch to EDB and still communicate/sync with the desktop using RAPI? As always, any advice is greatly appreciated, thanks!
According to SQL Server 2005 Book Online, the following "Important" note applies to SET_ANSI_NULLS and SET_ANSI_PADDING:
"This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."
However, these options are automatically inserted in the auto-generated scripts (such as CREATE TABLE) in SQL Server 2005 Management Studio.
I am working on new scripts that include these options. What are the replacements for these options? Does the above note apply to ALTER DATABASE options? Please give me advice!
I have a sql server express 2005 database with a table named Events with a column named Date (datetime datatype). I want a query that will display all rows that are either current or future but not past. I suspect there is a simple way of doing this. As a Newbie searching archived threads this is what I have come up with so far. I determine the number of days from present:SELECT DATEDIFF(day, Date, GETDATE()) AS NumberOfDays FROM EventsThis yields number of days from present with positive numbers in the past and negative numbers in the future. Thus setting a WHERE clause to <= 0 would limit my results to present or future events. Something like this:SELECT * FROM EventsWhere DATEDIFF(day, Date, GETDATE()) AS NumberOfDays <= 0The error message states: "Incorrect syntax near the keyword 'AS'"This feels like a clumsy way to approach this problem, but I have to start where I am.Any suggestions on how to proceed will be greatly appreciated.
I want to get into consulting (perhaps a little at first and more once I can support myself on it solely). I am about to start the purchase of a laptop soon, and I want to know which components I should focus on the most. I also want to know which version of SQL Server I should purchase.
From my studies and what I have learned (about to take the test to get my sql server 2005 certificate) I am going to assume that I want to get SQL Server 2005 developer software. However, the part that is not touched on very often, is if I am working with a client that has say, SQL Server 2005 enterprise, x64 exition, and I have developer IA64 edition, would I be able to connect and work on their server?
As far as the hardware is concerned, I am thinking I want a laptop with a large enough screen (I currently get a discount through hp where I currently work and am looking at the models that have a 17 inch screen) so I don't go blind trying to work . I am also thinking I don't need an extremely powerful processor, but I am not sure between athlon and pentium on which I Should choose since I do not have much experience in this area with sql server. I know I want at least 2GB of memory for the simple fact that sql server isnt the only thing I will be doing on the laptop and want some headroom. I also want a large enough hard drive to hold everything, but I definitely want to see if I can get a 7200rpm drive vs a 5400rpm for the simple fact that I have noticed a significant difference in read and write speeds between the 2 drives. I am not too fussed over the video card, as I am not into graphics design or high-end video games (I think world of warcraft is the most intense I have bought in years). I am also thinking that because I wont need to have a very powerful video card, that a mega powerful battery is not super important.
These so far are my thoughts. Please let me know your opinions on what I should focus on/get
I am doing a search on a column of type varchar, the columns all contain dates in the future. When i perform a query
SELECT [CIFPan]
,[CIFMemNum]
,[CIFLName]
,[CIFFName]
,[CIFExpDate]
FROM [FutureSoft].[dbo].[zCIFRecord]
WHERE CAST([CIFExpDate] AS smalldatetime) between '12/01/2000' and '01/30/2015'
I get error:
Msg 295, Level 16, State 3, Line 1
Conversion failed when converting character string to smalldatetime data type.
I can use this same query on an exactly same other field that contains dates in the past. Is there some kind of limitation on the dates as far as them being in the future or past?
I want to query my msdb job and jobschedule related tables to generate a list of runtimes for each of these jobs for the next day or any future date. This query should output JobID, Run_Date(YYYYMMDD), and Run_Time(HHMMSS).
If I have 3 jobs with...
Job#1 scheduled to run once every 4 hours between 6 AM and 10 PM Job# 2 scheduled to run every 15 minutes between 11 AM and 1 PM Job# 3 scheduled to run every minute between 4 PM and 4:15 PM
I've got a time series of the number of new customer subscriptions, which is the target attribute to predict. The number of subscriptions depends on various marketing activities, such as mailings, which are known within the time series for the past.
If I train an ART (MS Autoregression Tree), it learns the trend pattern as well as the correlations between the marketing activities and the target (cross-correlations), right? What I would like to do is, providing the model with some marketing activity planning for the future and let the model predict the number of new subscriptions based on a) the past trend pattern and b) the future activities.
Unfortunately a time series algorithm does not provide some kind of scoring for input data.
What would be the best approach to solve this problem? How about linear regression? But how to train a regression model with trend patterns?
i need to be able to do an sql call whereby i can check the day and hour for publishing.eg select story where day = ?? AND hour = ?? any one know the best way to do this. i need to call out date as a day number or someting and the getdate as just the hour??? anyone know how??
I am working with a data set containing several years' of monetary values. I have entries for past dates and the associated values, and I also have entries for future dates. I need to populate the values of the future date records with the values from the same date the previous year. Is there any way this can be done in Power Pivot?
i have written a sql function which returns only number of working days (excludes holidays and Weekends)  between given StartDate  and EndDate.           USE [XXX] GO /****** Object:  UserDefinedFunction [dbo].[CalculateNumberOFWorkDays]   Script Date: 10/28/2015 10:20:25 AM ******/ SET ANSI_NULLS ON GO
[code]...
I need  a function or stored procedure which will return the date which is 15 working days (should exclude holidays and Weekends) prior to the given future Date? the future date should be passed as a parameter to this function or stored procedure to return the date.  Example scenario:  If i give date as  12/01/2015, my function or stored procedure should return the date which is 15 working days (should exclude holidays and Weekends) prior to the given date i.e 12/01/2015...In my application i have a table  tblMasHolidayList where all the 2015 year holidays dates and info are stored.
i am trying to find a way to link an 'initial' Sale ID of a product to 'future' Sale IDs of products that will trace back to the original Sale ID.For example, if I call the original sale , 'Sale ID #123', how can i link future Sale ID's (child[ren]) and all future sales to the original Sale ID #123? Can I use a Surrogate Key or similar function?
Parent:Sale ID #123 Children:Â Sale ID # 456, Sale ID #789, Sale ID #.....
how I can link the original Sales ID (Parent) to Sale ID's (child[ren]) of future purchases currently existing and in the future going forward?
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.
I have an SSIS package (TransAgentMaster) that I recently modified to include a call to a child package via the file system. The child package creates a text file. When I run the package in dev studio then the child package/text file is produced.
I then imported the TransAgentMaster as a stored packagesfilesystem package into SQL SSIS and executed the package. The child package produced the text file.
I then ran the SQL Server Agent to see if the child package would work and it did not generate the text file. Thus after updating a SSIS package importing the package into SSIS the job that calls the package will not call the child package. Please not that the TransAgentMaster package calls 7 children packages €¦ just not my new one.
Any thoughts why the agent will not run the child newly crated childe package?
p.s. Does anyone have any needles I can borrow? I think sticking them in my eyes would be nicer than working with SSIS.
===================================
An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)
===================================
Could not copy object 'Preparation SQL Task' to the clipboard. (Microsoft.DataTransformationServices.Design)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=SerializeComponentsFailed&LinkId=20476
------------------------------ Program Location:
at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects) at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.InternalMenuCopy(MenuCommand sender, CommandHandlingArgs args)
===================================
Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)
------------------------------ Program Location:
at Microsoft.SqlServer.Dts.Runtime.PersistImpl.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events) at Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events) at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)
Hi. I need to import excel file in database. i first need to do an unpivot task. the column names are dates and SSIS seems to be unable to pick up the column name as it is replaced by F2 F3 F4etc Can you advise of a solution. thanks ken
I'm finding that the standard components often just don't quite meet my needs, but would only need some fairly minor changes to save me and my team a lot of work (and produce more elegant solutions). So I was just wondering whether the source code was available for the standard components that come with SSIS, or if there is anyway to extend their functionality? Or do you just have to start form scratch?
I need to build an asp.net/C# application to read values from an Excel spreadsheet. Once the values are read from the spreadsheet, the C# code will do some elementary statistics on the values read. Then the values read and their computations will be written to a sql server database. My manager suggested that SSIS might be a good candidate technology for doing this type of work. Does that sound correct? My only hesitation with using SSIS is that I want to keep the application as simple as possible, so that the code can be more portable. Maybe might argument is not a good one, but maybe someone can help me out here. Ralph
Dear Friends, I store several configurations in the main database of my SSIS packages. I need to get the servername from a xml or txt file in order to get those configurations stored in my database. How you think is the better way to do that? Using a FlatFileSource to read the file and a script to save the value into a SSIS variable? Using the package configuration I cant do that... maybe I dont know, but I can save the SSIS variale in the configuration file, but what I need is to do the inverse, read the configuration file and save the value in the SSIS variable. How the best way you suggest?! Regards!! Thanks.
We have SQL 2008 in development but only SQL 2005 in production. I have an SSIS package that was created in 2008 but need to deploy it to a SQL 2005 server. The '05 server will not import the package because of its version. Is there a way to convert back or 'save as' SSIS '05?
