General

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. LegiTest Server - Respect Regional Date settings.

    Throughout the Server, Dates are displayed in MDY date format.

    Please consider either :-
    1. Using the users preferred Date Format from their browser.
    2. Let the user set their user profile to decide their preferred format.
    3. Have a Server wide setting - default. As likely most users are in same country & you can still cache a standard format. )
    4. Take the Server setting on install from the Windows Regional setting.
    5. Pick either YYYYMMDD or DDMMYYYY as they are more logical than the standard US based format.
    YMD sorts better.
    DMY shows the Date & time…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Workbench Monitor - Ability to move tasks in layout to see other tasks.

    When Audit is applied to SSIS packages it often places its Rowcount tasks in an inconvenient place. Overlapping some other task making it difficult to read what displayed is underneath.

    There is not always time to update the layout so that it all looks nice. Especially when Audit is applied via the command line.

    BIX Server, has a really cool feature that lets you overcome this problem. It lets you move all the SSIS tasks around when you are viewing them.

    It would be nice if PW Client could do that too.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. nzload task

    can you please develop an ssis task to call NZLOAD which is the only way of inerting data in to netezza database ,
    If you need help please download TALEND ETL tool which has nzload as task the code is written in java

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bi xPress: Change Configuration Priority

    Maybe this is already possible but I haven't found a way to change the priority of the configurations in the Package Configurations wizard. I have been opening the BIDS SSIS native Package Configurations wizard to change the priority but it would be nice to do it in the BI xPress wizard as well.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Task Factory Advanced Email and SMS task: support for TCP/IP

    This task supports only SMS gateways for service providers. Adding support for TCP/IP would add flexibility for cases when the SMS gateway is not easily identified.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Provide an TF Salesforce Source task configure "Error Output" tab

    There is currently no way to see what columns of a TF Salesforce source component are set to 'redirect', 'fail' or 'ignore'. You must currently delete the OnError data flow path, recreate it, and then reset everything.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. HIPPA forms with Task Factory

    Three specifically are the X12 824, X12 837 and HL7 (here is a Google search of someone asking if SSIS can do this

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/402b737b-2eb8-4647-8146-eed553c379d7/ ).

    We are looking for an ETL tool so that we can work with these file formats. SSIS can’t handle them on its own and either needs custom programing (which I am trying to avoid) or a third party tool.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. BIxPress -Product Help files - Add a Project that will help introduce users to the product.

    The video's about the product are a good to get anybody started at the beginner level. However, it would be nice to have a downloadable project like the ones on codeplex that could help users give BIxpress a try and learn some of the advanced functionality of this awesome tool!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. We pull data from oracle but don't send allot of data too oracle.

    Oracle upsert is great, but with out datasource it is useless to us. 90% of what we do is pull data from oracle for processing with SSIS and put it in SQL Server or reports in SharePoint or crystal. We push very little data too oracle, its usually some huge proprietary application that can't be touched. I think you're going to see that alot with shops that deal with oracle.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add the Ability to Deploy Other Files in BIxPress

    I have a package which uses an Execute SQL Task, where the command comes from a .sql file. It would be good if that file could be deployed to the remote server, same as the config files can be deployed.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add new control flow Switch statement task

    Add a new task which, based on some input value such as a parameter or variable value determines course of action taken within the package. As an example, on a Data Flow, there is a conditional split that allows different course of action based on input values. Would like to see similar construct in Control Flow. We can somewhat get this effect using a TF Expression Task and expressions on the precedence constraints but the *else* or *default* action is more difficult to set up because it would need to be the NOT of all the other constraints. This gets…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. BiXpress missing index

    We are having performance problems on our database and Microsoft replied with a number of suggested changes and with the highest priority missing index is on your BiXpress database. The following is a quote from Microsoft:

     Found below are missing indexes.

    database_id object_id avg_total_user_cost avg_user_impact improvement_measure create_index_statement
    -------------------- -------------------- ---------------------- ---------------------- ---------------------- ---------------------------------------------------------------------------------------------------------------------------------------
    5 245575913 8.8581930202309 89.99 1713072.7 CREATE INDEX missing_index_51_50 ON [BIxPress].[dbo].[SSISDataFlowExecutionLog] ([sourceid], [executionid]) INCLUDE ([id], [event], [starttime], [message])

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Report coponents

    Add a report in the SSIS task, We should able to generate, send and print a report from the data extract. This will be used to generate and print data errors, analytical reports etc etc.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Object Lineage and Impact Analysis need improvise to list Source and Target making more sense.

    Object Lineage and Impact Analysis need improvise to list Source and Target making more sense.
    a. E.g. Show target or source if Flat file then Flat file, OLE DB then OLE DB etc, preferred with connection name

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. BIxPress - Report Deployment Tool

    It would be nice to be able to deploying reports from a file system to a Server or vice versa.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. BI xPress - Ability to automatically sync data between two environments based on some trigger.

    I would like you to offer a process that would allow automated syncing of data from say a test server to production based on some trigger. Thanks!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. BI xPress Server: Filter generated URL for the SSIS Execution Dashboard

    I would like to be able to save a URL for the SSIS dashboard with the filter already applied.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. BI xPress: Allow you to zoom in on expressions in the Expression Editor

    It would be nice to have the ability to zoom in on text in the BI xPress Expression Editor in case you want to make the text larger. If you can make this so it would work with the Ctrl+Scroll Wheel functionality for zooming that would be ideal.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

General

Feedback and Knowledge Base