We have a schema data that holds dates on an isolated machine. All dates ne...have a schema data that holds dates on an isolated machine. All dates need to be shifted according to a straightforward rule, creating a new schema with shift dates. A new ssis job should be introduced (not harming the current business logic). The work is at Ramat Gan.
We need MSBI developer who must be aware of SSRS, SSIS, SQL. It's long-term job support you need to give support every day. We will pay monthly Rs. 18000/-. Job support means I am busy with my personal works and you need to complete my office tasks. I will share my TeamViewer regularly when I have task you need to connect through it and complete the
I would like to plot a set of matrix (6 points in total) into a graphical visualization figure for the reader to understand. I have uploaded the figures that i have in mind, or otherwise you can propose something else which is simple to be understand. The matrix will be provided once the project is awarded.
I get about 50 excel files periodically over a quarter and need to get them into a MSSQL Database. The MSSQL database has dimension tables (CCY, Country, Sector, Asset, Fund ect...). The MSSQL database has a FACT table where I would like the data stored I'm happy with this structure. ---------------- TASK ---------------- I need a freelancer to create
I Need to get rewrite for web content for destination Travel Website @ $2 for 500 Words per Page Its quite simple task contents are already in word files writer will re-write them to get copyscape free content.
install and configure SSIS (and anything else required) to automatically export from sql server to excel, and email results (in excel format), on a daily schedule. also needs to be be able to run on demand. needs to be documented, capturing locations of files, packages, etc, usernames & passwords, and steps/process flow. you will log into my test server
5+ years of experience in MS SQL Server 2005, 2008, 2008 R2, SQL Server 2012 and 2016 databases * Thorough understanding of relational databases with good Knowledge of SSRS, SSIS, SSAS, Cubes * Should have worked in tables designing, Complex queries, CTEs, Views, Stored procedures, Function * High degree of communications and interpersonal skills *
...real business understanding of the economic world. In this role, I need to manipulate data in a lot of ways, retrieving data in databases and presenting it with a data visualization tools such as: -SQL servers -VBA macros - and full package range of Microsoft BI tools (SSAS, SSRS, and SSIS ) In that order i am looking for a person with knowledge
...The successful candidate will play an influential role in developing a best in class BI function. This is an excellent opportunity for an imaginative and people focussed developer who has the drive to assist with the development of a young dynamic business. The position is predominantly based in Goring-on-Thames; however, flexible and home working will
I need a logo designed. The name of my company is Future Destination. It’s a company that for information technology provides development mobile and website applications and also i want to note that i want to use the logo with another projects
...called https://www.traccar.org. We are looking to get every day email report for each device individually with below data. These reports are available already in the software but we would want it in an email. 1. First Status Login Time of the Day for the device (After 9AM) 2. Last Status Login Time of the Day for the device (Before 9PM) 3
Our goal is to migrate to Dynamics CRM Online. We own an SSIS (Integration Services) source and destination for [login to view URL] and Dynamics that can migrate the data called Task Factory. We do like every other company have dirty data with states and country names. Here are some of the steps we can think of but we’d like your input! Phase 1: Build a
Hi, We need an experienced SSIS developer who can develop a SSIS which work on delta sync basis. The scenario is: We have a SSIS scheduled to run every hour. So, we want to run it only for the items which has been changed in the past hour. The SSIS has multiple tables in it i.e. Resource Demand Time Phased Dataset, Assignment Timephased dataset, Projects
research same destination weight size on website of fedex, ups ,then the screen captures made on the dhl website and send me the screen captures
Getting an error importing date in format '17-DEC-2018' into SQL server date column, need to create correct transformation in SSIS. Please create instructions: provide string of code and where to insert it. Error is below Error: 0xC0049064 at Encounters_new, Derived Column : An error occurred while attempting to perform a type cast. Error: 0xC0209029
Immediate availability Need fast assistance from someone who's well versed with SSIS/CDC/SQL Must communicate with me so I can understand what's happening via Skype. - Create 6 Staging Tables for CDC (based on existing) - Generate Query to Return Data - Assistance with Best practices for Query and CDC Package Deployment
...SharePoint online (cloud). Want to connect using VS2017 package, SSIS. I want to connect to my SharePoint list (svc - I have the URL and can see the download) with an Odata source. Want to then load all this data into an SQL table. Only apply if you have had extensive knowledge with this SSIS and have used to odata connection for a shareoint integration
Hi I need a classy publicity for a travelmagazine Logo of as well the country ( sweden) as the touroperator ( destination green) should be present ( same size) As well as the slogan in dutch and french “Veruit de groenste partner van de reisagent, zeker ook voor Zweden, het hele jaar door” “certainement le meilleur partenaire écologique de
...requirements and design elements contained in a system specification. 2. Maintain and evolve software architecture documents based on evolving system requirements and industry trends and technologies. 3. Analyze risk and report problems in meeting system requirements. 4. Provide supporting information to the Engineers to aid in the creation of a system specification
We are looking for an enthusiastic and motivated team programmers for more than 6 months to handle our web application development in ASP.Net web forms and ASP.Net MVC with SQL Server 2008/12 as the database back-end. Technical Requirements : - Net developers with 3 or more years of experience - .NET C#, ASP.net core, MVC, ASP.NET, Windows Forms
...that all old links still work and point to the new one (simply from http to https). In theory all websites should work as before. However, the result we are seeing now is that Google Analytics traffic is significantly down. Google Adsense earnings are also down. In one specific website's case, the Ads are no longer rendering. We are starting to get
Help on the existing application in .Net, SQL Server, SSIS
Develop SSIS package, data from json api (REST) into sql. 1. I have a URL (which requires authentication) which accesses the JSON header. 2. This json header data will need to be stored into an sql table 3. A loop will need to be created to go through the JSON header sql table (to find the line url data) 4. This json line data will need to be stored
simple web app that enables me to configure an url slug and where a page is served to the user that first fires a Facebook pixel event and redirects the user to the destination URL after.
hello i need help in writing SSIS package without sorting header record and trailer record. only actual data should be sorted on 1st column which has length 1 character. sample Input File([login to view URL]) H1020XXXXXXXXXX 509090909092343 132423423432434 343242342342343 T12295834958 sample output file([login to view URL]) similar to below: H1020XXXXXXXXXX
...want to avoid sending several emails to destination email addresses that have already been bounced. I have a list in a database (currently sqlite, and also a flat file) of banned email address, namely addresses that have been previously bounced. I would like to configure postfix to reject target that are present in that list. namely, I would like postfix
Hi Team, I want to search some part time work on BI technologies like Power BI/ MSBI (SSRS/Ssas/Ssis) Also worked on Cloud computing like Azure/AWS and Database Migration. Please find the below link so that I have created some Power BI Dashboard/Reports:-- Please find below Power BI Dynamic Dashboard. [login to view URL] Details [login to view URL]
Hi i would like to make my website [login to view URL] new mock up set, i am attaching my file for more details i need following:- 1 Index mock up with a...provide. We do not code we need mock up as par our file, CSS File and html design 100% responsive, PLS THINK IT MORE to mobile user friendly. also booking voucher we need in mobile version
Locaguide is a startup in travel domain, our travel portal intent to provide and customized guided tour experience to our customers We are in search of freelancers to pitch in for our huge requirement of destination related content work
HI I need a simple solution to load xml file with multiple namespaces to sql table , Ideally via SSIS but stored procedure will also be ok . As file contains multiple namespaces with various depth standard SSIS XML data flow task is failing to import all the data. XML file is the response from ebay api LMS saved on local PC.
I'm working on a SSIS package, need help to build through the tasks, could be quite simple for SSIS developer. We can finish it quickly where going over it together online (Webex). The package needs to: get a table object variable, use foreach loop to process each row, each row has components of a custom sql, run the custom sql and store end result
I am working as Data Warehouse Engineer. And I need some support(proxy) to help in my work. Its related to Data Migration and requires creating ETL mapping documents, maintaining them, ER diagram development, writing SQL queries, creating SSIS packages.
After running the ad for years this morning my ad has been disaproved. I need to fix it. The landing page works fine, no obvious problem detected...
Small work. Issue in oracle database integration unable to solve it because of lack of knowledge in SSIS. should be like 10 mins work for experts. Recently Domain of BI server was modified then we started to have this issue. I don't know the username and password of userID used in scheduled job, wanted to make it work again.
We are creating a website for homesharing (Air BNB and other such means of home or room rental) and some US state governments require report...likely be the same. The current need is the state of Pennsylvania . We currently don't know the database source but believe it will be either mySQL or SQL. We are thinking SSIS or C# skills would be helpful.
Summary: PHP script or SSIS to update products on bigcommerce (api V3) using records in table on sql server Details: - fetch records from my table in sql server (over 20k records) - use that data to update existing products in bigcommerce (e.g. updating categories, description, price, inventory or any other field) - respect the bigcommerce api/hr limit