• How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    Deepanshu35 pointsBadges:
  • Assigning access to SQL Server Integration Services (SSIS) packages

    How do we assign access for users to SQL Server Integration Services (SSIS) packages?

    SQL Server Ask the Experts2,585 pointsBadges:
  • About data management

    Hi i have same date like this; 1 ..... ..... 2 ..... ..... 3 -26 -28 4 36 -53 5 -40 -46 6 ... ..... 7 56 -64 8 -31 -29 ı want to change this date like this 1 ..... -28 2 -26 -53 3 36 -46 4 -40 ... 5 ... -64 6 56 -29 7 -31 ... 8 ... ... one column go up a line other column go up two line but...

    Bronzemoon5 pointsBadges:
  • Working with totals

    I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?

    Spcase5 pointsBadges:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • How do I integrate SQL Server Integration Services and Blaze Advisor?

    I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
  • SPSS, Tuckey problem

    Hi, In my SPSS data I have found a (significant) main effect. Now I want to explore this effect, to see what is the cause of it. I would like to find a contrast in an interaction. At this point I have split the file "manualy" by using split file, and then conducted: general linear model ->...

    Stijn5 pointsBadges:
  • Download files from a sharepoint site using SSIS.

    Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.

    ToWin5 pointsBadges:
  • Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: 1. Select the max(to_date) + 1 from a table in SQL Server. 2. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • How SSIS works with cluster SQL and non cluster SSIS service?

    According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the situation that I have where I need to understand how SSIS works? Enviornment: Active Active cluster enviornment for SQL server with SSIS server...

    Munnu5 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • Trying to enter back into a field

    I'm trying to re-enter back into the Business Analyst field. My previous employer changed the tasks until I was no longer utilizing my skills. This job I stayed with for 2 1/2 yrs. What do I need to brush up on? I see tons of Business Analyst positions however, for the most part all require...

    Gnaff909320 pointsBadges:
  • SECURE FTP SITE ON Windows 2003

    We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a...

    Mconfer0 pointsBadges:
  • Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2

    I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I borrow a PC...

    Kfink040 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following