[SQL Server] Is this right if i will do my project this way?.. |
- Is this right if i will do my project this way?..
- SQL Agent Job error
- Disable a Calculated Parameter ssrs report using SQL Server 2008 r2
| Is this right if i will do my project this way?.. Posted: 01 Oct 2013 02:51 PM PDT Hi Everyone..I hope everyone is having a nice day:-)Is this right if i will do my project this way?Please see my attachment |
| Posted: 01 Oct 2013 04:10 AM PDT Hi,I am experiencing the following error below. I have an update uncf processes job that has 35 steps. The job runs automatically until it gets to step 15 Create.CSV. I need to find out how to have the job run automatically through all 35 steps. Pls help! Thanks.Update NCF Processes,Error,15,SQL04,Update NCF Processes,Create Update.csv,,Executed as user: NCF\sql_services. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:20:23 PM Error: 2013-10-01 12:20:53.63 Code: 0xC020200E Source: Create CSV Flat File Destination [2672] Description: Cannot open the datafile "J:\Projects\NS to SF\NS Contacts Update with Org\update.csv". End Error Error: 2013-10-01 12:20:53.63 Code: 0xC004701A Source: Create CSV SSIS.Pipeline Description: component "Flat File Destination" (2672) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:20:23 PM Finished: 12:20:53 PM Elapsed: 30.202 seconds. The package execution failed. The step failed.,00:00:30,0,0,,,,0 |
| Disable a Calculated Parameter ssrs report using SQL Server 2008 r2 Posted: 30 Sep 2013 08:34 PM PDT Hi,I have a Report created in SQl Server 2008 r2,in which i'm passing 3 parameter to the querythe third one is calculated on the basis of other twowhen the there is no data in first two fields there is no data then the third field is disable but when the value is inserted in the two fields then the third field is enabledi don't want the third field to be enabled(it should be read-only) even if the calculated data is comes inside the third field before value[img]http://i869.photobucket.com/albums/ab252/write2varun/2_zps7daa7ee8.jpg[/img]after value[img]http://i869.photobucket.com/albums/ab252/write2varun/2_zps7daa7ee8.jpg[/img]P.S. I'm new with ssrs reportthank you |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment