Search results for query: *

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

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...

Brilliant. Thanks lbass

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...

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?

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...

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...

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

Thanks Bill ... that's great

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...

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

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...

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...

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

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...

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...

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

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...

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]...

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