Recent content by Motlatjo

Hi AzuMithu I think the issue is how you configured you Flat File connection Change it to expression in the properties, then it will be able to change the source to each file it is pointing to Regards

Hi My issue is after deploying my cube, all the dimensions are visible on Excel, but only 3 are showing on SSMS I want all of them to show on both Please help Regards

Hi Burakcan When Editing you Cube Dimension, click on the field you want to hide, and in the properties window, set AttributeHierachyVisible to False Regards

Hi flobird To rename sheet http://vijirajkumar.blogspot.co.za/2010/04/rename-excel-sheet-net.html To rename the file use SSIS File System Task Use Foreach Loop Container to load files that begins with "Tender..." Hope that can help

Hi pndMaster I was thinking about something along this lines Tell me what you think DECLARE @ClientId INT = 1 , @ClientLName VARCHAR(20) = 'Motlatjo' , @ClientFName VARCHAR(20) =NULL , @ClientDOB DATETIME ;WITH pndMaster AS ( SELECT 1 ClientId , 'pnd' ClientLName , 'Master' ClientFName ...

Hi I am creating a data warehouse that is sourcing millions of records. I am using Slow Changing dimension and TSQL views to process the Dimensions and FACTs Now performance is very bad How can i make it better? Thank you in advance

Hi If your error is: [Flat File Source [2]] Error: Cannot open the datafile "...csv". Try closing the CSV file and rerun the Task

Hi Michael To my understanding, your job fails when it tries to send a message. First ensure that your Messenger configurations is correct and well tested. Use the below query to test it on Management Studio: EXEC msdb.dbo.sp_send_dbmail @profile_name='Your Prifile Name'...

Hi Can you please recommend a site where i can be able to learn more about the underlying topic Thank you

Hi Surendarorion Lets first start by debugging. Include a Data Viewer before the OLE DB Destination and see if the problem is with the Source or the Destination. The other thing you can do is to preview the data on both the Source and the Destination. Regards

Hi vfspb Look for a Data Flow Transformations task called Fuzzy Lookup, that will help you clean up your data. If you want me to explain how the whole process will work out, let me know. Regards

Hi Kevin Try this Lets call original data the Source, and the Backup will be the Destination I believe that your Source have Primary keys. After creating the tables on the destination, open you SSIS project. Pull in a Data Flow Task per each table, and have your OLE DB Source and Destination...

Hi Create a proxy user with the administrator privileges and run the job under the user.

Hi Michael I have been importing data where by one of the destination columns is an Identity field, though i do not get warning messages, can you please tell us what the warning message say? Before you can ignore the message, check if you data is as expected. Thanks

Hi Phil The package runs successfully from the Integration Services Catalogs and from the SSDT project. I found a solution to the problem. Let me know if you want me to explain further Thank you