Search results for query: *

Have you verified your credentials to that Report Server? Thanks

Can you please elobarate your question? Thanks

Are MyServer and the reporting server both same? If Myserver is different server then copy the cube from Myserver to Reporting server and point connection to reporting server. Thanks

If you want to change font for the report layout you can go to the design tab and change the font as per the printer. Please let me know if i understood your question in wrong way. Thanks

datasource1 could be the wrong server name. Change that to the correct server and with valid credentials. Thanks

To find out the non numeric values, The below query would be fine SELECT * FROM ProductFields WHERE ISNUMERIC(Mobile_GPV) = 0 Thanks

Get the data in to temptables in the database where the actual tables resides. Once the data comes then insert the only in to actual data that aren't already exists. Good Luck Gopala Krishna Kakani

Hi, First load the data to another staging table. Compare that staging table with destination table and insert only new record in to destination table. Yes, You can do this comparison within the DTSPackage. Thanks Gopal Good Luck Gopala Krishna Kakani

Hi Create DTS package, With ActiveXScript Task to parse the data and Data Transformation Task to load the text file. Good Luck Gopala Krishna Kakani

Try this SELECT A.`Part No`, A.`Selling Unit`, A.`Customer No`, A.Description, A.`Bus Unit`, A.`Prod GP`, Format(`Cost Price`, 'Currency') AS `Cost Price`, Format(`Latest Price`, 'Currency') AS `Latest Price`, A.`Prices Type`, A.`Product Manager`, A.`Effective From Date`...

What would happen if you open too many applications in a system equipped with low memory ??? Good Luck Gopala Krishna Kakani

That time string should be like this 1900-01-01 9:00:00.000 Good Luck Gopala Krishna Kakani

SmallDatetime, Good Luck Gopala Krishna Kakani

Good Luck..... BOL is the best tool to read. Good Luck Gopala Krishna Kakani

Why you want to UPDATE those records through DTS. Are you going to repeat this UPDATE process again. You can UPDATE the recrods in DTS package With the Task "Execute SQL Script". Use the following sub query to join with your sql server table and write update command. select * FROM...

Not at all. You can keep data length more with data type varchar. It doesn't effect any thing. Good Luck Gopala Krishna Kakani

In the DTS Transform Wizard. After selecting Souce and Destination, you just click on the Transformation button. Column Mappings and Transformations Window will appear. just select the Source column and Destination columns which are related to order data. so only order data will go in to order...

Hi, I checked this As you mentioned above. Its showing correct count in EM. Good Luck Gopala Krishna Kakani

You just run SP_DEPENDS before modifying any schema on the database. By that you can get a list of stored procedures which depends on that table. Good Luck Gopala Krishna Kakani

If you are into sqlserver Use Enterprise manager to add new column in between existing columns by inserting the row in between the columns. Or Try the following script BEGIN TRANSACTION CREATE TABLE dbo.Tmp_Dept ( [Dept id] char(10) NOT NULL, NewColumn char(10) NULL, [Dept name] char(10)...