Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TeamGD

    SQL Server OLE DB Password prompting each time

    Excellent. Thanks briangriffen and kray4660. That works a treat.
  2. TeamGD

    SQL Server OLE DB Password prompting each time

    Hi all, Crystal Reports 2011 Crystal Server 2011 In a number of reports I’ve connected to a SQL Server 2008 database using OLE DB (ADO). I have been given a SQL Server account that I’m to use for all reports to connect to the database. I’m prompted to enter the User ID and Password on the...
  3. TeamGD

    Chart: Edit Axis label

    Brilliant. Thanks lbass
  4. TeamGD

    Chart: Edit Axis label

    Hi All, Crystal 12.2.0.290 I make changes to the Displayed Label of the Axis label of a Chart and to the format size. I then exit Crystal reports and when I re open the report all, bar one, of the Displayed labels have reverted back to the default, and their size has changed. Yes, I am...
  5. TeamGD

    How Tha Do i get the package on SQL

    After building a solution, with many packages, and then deploying all the packages to SQL Server by executing the manifest… if I then make a change to just one of the packages how do I deploy just this one package and not all packages?
  6. TeamGD

    IS Package wont work for anyone but me. Why?

    As footnote … I resolved my issue by deploying all packages to SQL Server (previously they were on the file system) and selecting “Rely on server storage for encryption” in the Package Installation Wizard. I do not know what caused the issue in the first place ... I'm just glad to move on from...
  7. TeamGD

    Connect to Integration Services from Management Studio

    I have resolved my issue … but the path took a few twists and turns. I added my user name to the SQLServer2005DTSUser$<server name> local group … however this still did not allow me to connect to Integration Services via the Management Studio. After doing more research I discovered that the...
  8. TeamGD

    Connect to Integration Services from Management Studio

    Thanks Paul Where do I determine the Windows Group(s) that have permissions to connect to Integration Services from the SQL Server Management Studio? Greg
  9. TeamGD

    IS Package wont work for anyone but me. Why?

    I’ve had a job scheduled in SQL Server Agent that has been working for months. Now a number of the steps, which are IS packages, are not working and the error message is exactly the same as discussed in this thread. The packages have not changed. The Network Administrator assures me nothing...
  10. TeamGD

    Connect to Integration Services from Management Studio

    I’m unable to connect to Integration Services from the SQL Server Management Studio. However the Network Administrator can. I can connect to Database Engine using Windows Authentication. Where is the connection access to Integration Services from SQL Server Management Studio administered? cheers
  11. TeamGD

    flat file source with varying columns in a foreach loop

    Hi all I have numerous flat files (csv) that I want to use a Data Flow in a ForEach Loop Container to extract and then insert into a single SQL Server 2005 table. All the flat files have a number of columns that contain common data. The flat files also have a number of columns that are unique...
  12. TeamGD

    Loop to change ODBC DSN Problem

    Thanks everyone for your input. We’ve come up with a reasonable solution. It’s not best practice … but it works. In short we have an outer package that does the looping. One of the steps in this loop executes another package (i.e. inner package) and passes the relevant variables. This...
  13. TeamGD

    Loop to change ODBC DSN Problem

    Catadmin, I use a SQL Task with Global Variables to determine a loop counter. I use a Dynamic Properties Task to set DataSource Property at the start of each loop, and I use a Dynamic Properties Task to set the ExecutionStatus Property at the end of each loop. cheers gmhm
  14. TeamGD

    Loop to change ODBC DSN Problem

    Thanks CatAdmin & AlexCuse. CatAdmin, I agree that what you’re saying certainly appears to be what is occurring … but I do not have the experience to resolve this. I’ve mucked around with including Begin Transaction & Commit in a SQL Task within the loop … but with no success. Do you have...
  15. TeamGD

    Loop to change ODBC DSN Problem

    I have a loop that is meant to transform data from multiple ODBC sources into a single SQL database/table ... but it is not working. Without the loop the transform works fine for one ODBC source. I have eight proprietary databases that have exactly the same database name, table names and...
  16. TeamGD

    Derived Column isnull with a date

    manmaria ... I've since found the solution. I needed to cast the date as per below. ISNULL(hrs_client_dob) ? (DT_DBTIMESTAMP)"1753-01-01 00:00:00.000" : hrs_client_dob Thanks must go to manmaria in the SQLServerCentral.com forum. Cheers gmhm
  17. TeamGD

    Derived Column isnull with a date

    Thanks for responding manmaria. The expression is in red. If I click on OK, the Microsoft Visual Studio error is: Error at Dim_Client [Replace Nulls[1132]]: Attempt to parse the expression “ISNULL( [hrs_client_dob] ) ? 1753-01-01 00:00:00.000 : [hrs_client_dob]” failed. The expression...
  18. TeamGD

    Derived Column isnull with a date

    In a Derived Column transformation I want to transform a date such that if it is a null then replace it with 1753-01-01 otherwise keep the date value. However I’m getting an error. I’m using the following expression: ISNULL( [hrs_client_dob] ) ? 1753-01-01 00:00:00.000 : [hrs_client_dob]...
  19. TeamGD

    Extract data from a web page

    Catadmin, Thanks for your help on this one. We've found an alternative data source for the data we require. So I won't be pursuing extracting data from the web page. Thanks once again. Cheers gmhm

Part and Inventory Search

Back
Top