Date Range
Date Range
Date Range
Friday, March 30, 2012. Problems Linking to Oracle Server. Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working. have installe dvarious drivers and still get connection refused. Any thoughts? If this is a Linked Server issue I would try the SQL Server Engine forum. Problems linking Access to SQL replicated tables. I was wondering if anyone could help me. I am running an Access application that uses linked tables to connect to a SQL server.
Friday, March 30, 2012. I have a weird problem with SSIS package. Package is deployed and save on SQLServer2k5. It runs no problem if I start from Integration services. It fails every time when it is scheduled as a job. I will appreciate any advice. Are you using a data source that is sql authentication? Thank you Brent,.
Friday, March 30, 2012. I have a table with 5 primary keys. I have clustered index defined on. However, I can see that this index is only using three. Why is that? I for some reason when I run queries I get index scan as opposed to. TIt sounds like the indexes you have are not working for you. For us to assist you, please post the table DDL, along with a query or two. That you believe do not properly use indexing.
Friday, March 30, 2012. When I manually run the IS packages to load the data warehouse and then process the dimensions and cubes, everything works fine. When I schedule the packages as jobs, eventually the data goes wrong. The jobs are scheduled in the correct order. If I get your description right, the SSIS packages are not executed in the correct order. Is that so? You can also use SQL Agent jobs directly to send processing commands to Analysis Serivces. Eventually the data goes wrong.
Le petit monde de lili. Bienvenue dans mon petit monde, avec mes coups de coeur et mes coups de gueule. Oh je sais, je ne suis pas la première à faire cela, ni la dernière. Abonne-toi à mon blog! Tout a commencé par là.
Quand tu est né il pleuvè car dieu venè de perdre son plus bel ange. Voici ma ptite live en image a vous de lausser des commentaire et gros gros bizoux a tous. Je vous présente Maëlys ma ptite chérie. Retape dans le champ ci-dessous la suite de chiffres et de lettres qui apparaissent dans le cadre ci-contre. Mon ti frère qui est plus grand que moi.
Friday, March 30, 2012. I have a weird problem with SSIS package. Package is deployed and save on SQLServer2k5. It runs no problem if I start from Integration services. It fails every time when it is scheduled as a job. I will appreciate any advice. Are you using a data source that is sql authentication? Thank you Brent,.
Friday, March 30, 2012. I have a table with 5 primary keys. I have clustered index defined on. However, I can see that this index is only using three. Why is that? I for some reason when I run queries I get index scan as opposed to. TIt sounds like the indexes you have are not working for you. For us to assist you, please post the table DDL, along with a query or two. That you believe do not properly use indexing.
Friday, March 30, 2012. When I manually run the IS packages to load the data warehouse and then process the dimensions and cubes, everything works fine. When I schedule the packages as jobs, eventually the data goes wrong. The jobs are scheduled in the correct order. If I get your description right, the SSIS packages are not executed in the correct order. Is that so? You can also use SQL Agent jobs directly to send processing commands to Analysis Serivces. Eventually the data goes wrong.